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.

Let us consider the working principle of the given functionality on an example of a grid (the highlight rule – line color range):

We display only 7 subcategories with the best values of “Order Count” measure:

The following parameters are available in the form:

• Enabled – enables/disables this functionality;
• Mode – specifies whether top or bottom values should be displayed;
• Count – the number of values to be displayed;
• Measure – the parameter according to which the top or bottom values will be determined.

Fill out the form as follows:

As a result, the table looks the following:

And now let us add the “Category” dimension to the columns and we get the following result:

Now we have 7 best “Order Count” measure indicators for each product category.