The rank functionality will add a ranking number to the items in a table based on the result. The result can be based on any calculation type: mean values, percentage shares, count etc.
The rank can be displayed on its own or together with the original values:
- Result with ranking in one column
- Only the ranking
- The result and the ranking in separate columns
Below you will see three examples of showing rank in a table.
As well as showing the rank of all items in the table, as in the examples above, it is also possible to show the rank for a specific selection, based on the choice made in the optional filter area (for instance a brand, a campaign, a unit in the hierarchical structure etc.) even if the other values are not shown in the table. This is very useful when a user would like to be able to see the rank of his/her unit/brand but not the others.
Note: the rank is based on all decimals, rounded values are not used to calculate the rank. If two or more items have the same result they will get a shared rank. The next rank will skip 1 value. Example:
- Company B has the same score as company A, and company C is the highest, A & B will both have rank 2. Company D has the lowest rank and will get 4 assigned.