Rank KPI

[GeorgeEard]

I would like to have a KPI visualisation that if a particular Partner is filtered, then it shows the number reflecting that partners rank compared to others count of agreements.

I am currently using '=aggr(rank(sum({<Partner>}Agreement)),Partner)' however this is showing the incorrect rank.

I have create a table to show the Count(agreement) by Partner and have a column to rank those with Rank(count(agreement).  

Is there a reason the ranking shown in the KPI is inaccurate?

[sbaro_bd]

Hi @GeorgeEard ,

Can you provide some sample? Tell us what result you expect and which one you get (the incorrect one).

Regards.

[GeorgeEard]

For example if I select the partner with the 4th highest number of agreements my KPI is saying their rank is 12 when it I would like it to say 4.

[JandreKillianRIC · Accepted solution]

Hi @GeorgeEard 

I just tested this and its working. The only thing I am seeing on your side (Might just be a typo) but is a mismatch of sum vs count. 

"I am currently using '=aggr(rank(sum({<Partner>}Agreement)),Partner)' however this is showing the incorrect rank.

I have create a table to show the Count(agreement) by Partner and have a column to rank those with Rank(count(agreement)."