Top N

The Top N feature allows you to display only a limited number of values that correspond to the highest or lowest values of a particular measure.

To enable the Top N feature, open the dashboard item Binding menu, select a required data item and go to the Top N section.

Click ON and specify the following settings.

Measure

The parameter according to which the top or bottom values will be determined.

| |

Count

The number of values to be displayed.

| |

Mode

Specifies whether top or bottom values should be displayed.

| |

Show “Others” value

If enabled, all values that are not the top/bottom ones are consolidated in the “Others” value.

Note

Note that this capability is not supported in OLAP mode.

You can use the hidden measure as a parameter according to which the top or bottom values will be determined.

Limitations

The “Others” value has the following limitations:

You cannot set the “Others” element as a Master Filter value.
Drill down by this value is not supported.
You cannot obtain Underlying data only for the “Others” value. As an alternative, use the Data Inspector to obtain underlying data for the whole dashboard item.