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. 
 
Company A2
Company B2
Company C1
Company D4