About Top Bottom N Filters

You can use Top Bottom N filters for all filter scopes to filter an attribute or measure to display a subset of its highest or lowest values.

For information about filter scopes, see Filter Scopes.

For example, you can filter a visualization by the top 10 cities based on sales. You can define a Top Bottom N filter in the filter bar to show the top 10 cities with the highest sales.
Description of filters_topbottomn_salesbycity.png follows
Description of the illustration filters_topbottomn_salesbycity.png

You configure the following three properties to create a Top Bottom N filter:

  • Method - Specifies whether to filter by Top (highest values) or Bottom (lowest values).
  • Count - Specifies the number of values to display. For example, the top 10 or the bottom 5.
  • By - Specifies which measures or attributes to limit the filter by. If your filter is an attribute, you can choose which measures to limit it by. If your filter is a measure, you can choose which attributes to limit it by.