Ranking Filter

Note: IT Visibility is being upgraded with the introduction of Technology Intelligence Platform beginning in September 2024. Flexera will contact you directly regarding the timeframe of your upgrade. With Technology Intelligence Platform, out-of-the-box IT Visibility dashboards are being replaced with new, enhanced IT Visibility Technology Intelligence Platform reports. For more information, see IT Visibility With Technology Intelligence Platform Reports.

In Data Explorer, 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 Data Explorer.

To configure the Ranking filter:

In the insight you want to filter, click the filter bar icon.

Select Top/bottom values.

Click Apply.

Data Explorer 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:

Click the filter in the filter bar.

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.

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).

In Based on, select a measure to use for filtering.

Click Apply.

Data Explorer 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 Data Explorer 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, Data Explorer 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, Data Explorer displays both.