User Guide
×
Menu
Index
 

Adding Rank

 
When performing calculations using KPIs, it is possible to add rankings to the Spreadsheet. Categories of the "Object" variable can then be 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

Further options

4. Further 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.
 
5

Dense ranking

5. Dense ranking
If this option is chosen, dense ranking is applied. In dense ranking, items that compare equally 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 category of the "Object" variable.