User Manual
×
Menu
 
 

Adding Rank

 
 
When performing calculations using KPIs it is possible to add rankings to the Spreadsheet. Categories of the "Object" variable can then ranked by e.g. the value of the chosen KPI or the unweighted count. To do that, first click on the menu related to output styles for the KPI for the option "Add Rank" to be displayed:
 
 
 
 
To add a ranking to the results, choose the desired settings and press the "OK" button:
 
 
Adding Rank
1

Ranked variable

1. Ranked variable
Choose the variable to be ranked.
2

Ranked by

2. Ranked by
Choose what the categories of the variable should be ranked by.
3

Ordering type

3. Ordering type
Choose the ranking order - Ascending or Descending.
4

Additional options

4. Additional options
Show or hide the additional options.
5

Futher options

5. Futher options
 
It is also possible to choose whether the values should be ranked by exact or rounded values. If rounded values are chosen type of rounding by which the ranking will be made has to be specified.
 
6

Dense ranking

6. Dense ranking
If this option is chosen, dense ranking is applied. In dense ranking, items that compare equal receive the same ranking number, and the next item(s) receive the immediately following ranking number.
 
 
When the Spreadsheet is generated, ranks appear in one of the columns, each for every kategory of the "Object" variable.