Ranking Filter

Contents:

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 Measures section and one attribute or date (in other than the Measures section), except Headlines, can have one top/bottom value filter. The filter is applied after the date, measure value, and attribute filters.

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

The filter is also applied when you add the insight to a KPI Dashboard. However, you can edit the filter settings only in Analytical Designer.

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 measure 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 measure to use for filtering.
  5. Click Apply.

Analytical Designer now filters your data according to your configuration.

  • To use the ranking filter and also filter measures by values, you must select All in the Out of section. If you want to select one attribute in the Out of section, disable the measure value filter.
  • The ranking filter is not compatible with the Rollup (total) aggregate function in tables. If you use this aggregate function and enable the top/bottom filter, the rollup (total) is removed.
  • If you display a measure in per cent (the Show in % option is selected for the measure), the ranking filter disables this option.

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 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,601 (yellow) → 5 and 6
    Since the two items have the same value, Analytical Designer displays both.






Powered by Atlassian Confluence and Scroll Viewport.