Ranking Filter

Overview

In Analytical Designer, you can filter your data by a number of top or bottom values. For example, you can display the top 5 restaurants based on their revenue.

Each insight with at least one item in the Metrics section and one attribute or date (in other than the Metrics section), except Headlines, can have one top/bottom value filter. The filter is applied after the date, fact/metric value, and attribute filters.

You can use any local fact or metric (that is, any fact or metric already in your insight) to filter by its top/bottom values.

Configure the filter

  1. In the insight you want to filter, click the filter bar dropdown icon.
  2. Select Top/bottom values. 

  3. Click Apply.

Analytical Designer adds the filter to the filter bar. The default setting is top 10 values out of all attributes based on the first fact or metric in the insight.

To edit the filter:

  1. Click the filter in the filter bar. 

  2. Select if you want to see top or bottom values and specify a number. You can select the number from the dropdown menu or write your own.
  3. In Out of, select the attribute whose values will be filtered. You can select one attribute or All attributes (if your insight includes multiple attributes).
  4. In Based on, select a fact or metric to use for filtering.
  5. Click Apply.

Analytical Designer now filters your data according to your configuration.

Examples

Your insight contains Daily Total Sales of your restaurant viewed by Year and Menu Category.

You want to see which are the top three menu categories that sold best each year - select Top 3 out of Menu Category based on Daily Total Sales.

You want to see which are the top five menu categories that has sold best - select Top 5 out of All based on Daily Total Sales.

Why does top 5 display 6 items and only 4 values?

If multiple items have the same value, the ranking filter in Analytical Designer shows all items with this value. The insight may then display more items than the number set. 

Example:

You want to see the top 5 menu categories that sold best.

The table displays 6 items with 4 different values (the last example above, now shown in a table).

Explanation:

  • The highest sales value is $44,797 (red in the image) → 1
  • Then two items with $44,693 (blue) → 2 and 3 Since the two items have the same value, Analytical Designer displays both.
  • Then $18,101 (green) → 4
  • Then two items with $18,061 (yellow) → 5 and 6  Since the two items have the same value, Analytical Designer displays both.