Dashboard with Top N

When creating reports you can apply the TopN filter to the following elements: Chart, Indicator, Progress, Pivot table.

 

The following questions will be considered in this chapter:

The TopN in the Chart;

The TopN in the Indicator;

The TopN in the Progress;

The TopN in the Pivot table.

 

 

Chart

 

Step 1: Create a dashboard with the Chart element;

 

Step 2: Select the element;

 

Step 3: Click the TopN button of the current element;

 

 

 

Step 4: Select Top or Bottom mode in the TopN editor;

 

 

 

Step 5: Set the number of the TopN with the help of the Count parameter;

 

 

 

Step 6: Set a checkbox for the Show Other parameter, if you need to sum all values, which will not be included in the list of the TopN and display them as one value;

 

Step 7: Specify a header for other values in the Other text field, if it`s needed.

 

 
 
Step 8: Close the editor of the TopN;

 

Step 9: Go to the Preview.

 

 

 

Indicator

 

Step 1: Create a dashboard with the Indicator element and its rows;

 

Step 2: Select the element;

 

Step 3: Click the TopN button of the current element;

 

 

 

Step 4: Select Top or Bottom mode in the TopN editor;

 

 

 

Step 5: Set the number of the TopN with the help of the Count parameter;

 

 

 

Step 6: Set a checkbox for the Show Other parameter if you need to sum all values, which will not be included in the list of the TopN and display them as one value;

 

Step 7: Specify a header for other values in the Other text field, if it`s needed. The Other header is applied to them by default.

 

 
 
Step 8: Close the TopN editor;

 

Step 9: Go to the Preview tab.

 

 

Progress

 

Step 1: Create a dashboard with the Progress element and its rows;

 

Step 2: Select the element;

 

Step 3: Click the TopN button of the current element;

 

 

 

Step 4: Select Top and Bottom mode in the TopN editor;

 

 

 

Step 5: Set the number of the TopN with the help of the Count parameter;

 

 

 

Step 6: Set a checkbox for the Show Other parameter if you need to sum all values, which will not be included in the list of the TopN and display them as one value;

 

Step 7: Specify a header for other values in the Other text field, if it`s needed. The Other header is applied for them, by default.

 

 
 
Step 8: Close the TopN editor;

 

Step 9: Go to the Preview tab.

 

 

Pivot

 

Step 1: Create a dashboard with the Pivot table element;

 

Step 2: If the editor element is not displayed, you should double click on the Pivot table;

 

Step 3: Select the data columns for which you need to display the TopN in the Rows or Columns field;

 

Step 4: Click the TopN of the current element;

 

 

 

Step 5: Select Top or Bottom mode in the TopN editor;

 

 

 

Step 6: Set the number of the TopN with the help of the Count parameter;

 

 

 

Step 7: Select the summary field, which values will be analyzed in the field of the Measure parameter;

 

 

 

Step 8: Set a checkbox for the Show Other parameter, if you need to sum all values, which will not be in the list of the TopN and display them as one value;

 

Step 9: Specify a header for other values in the Other text field, if it`s needed. The Other header is applied for them, by default.

 

 
 
Step 10: Close the TopN editor.

 

Step 11: Close the Pivot table editor;

 

Step 12: Go to the Preview tab.