Understanding Rank in KPI

[samnoor_27]

Hi,

I wish to understand how the Rank function actually works.

In the table "Ranking" in attachment, I wish to get the top 5 Organization and displays the count of the top 5 in a KPI object.

My set analysis to get the top 5 and compute the total number of Tickets is as follows:

=Count({<Organization = {'=Rank(Count(Ticket))<= 5' }>}Ticket)

Logically I should be getting 10 as result (3+2+2+2+1), but I fail to understand why the set analysis returns 9!

FYI: top 2 to top 13 results in 9

As from top 14, result is 31

Thanks to advise on this issue

[samnoor_27]

OMG, it works like a charm @sunny_talwar ! 🙂

Can you please care to explain the reasoning behind? Sorry for the stupid question, I'm a newbie! 😛

Many thanks!

[sunny_talwar]

Rank function takes multiple arguments, the 2 argument (where I used 4) is assigning it incremental value as oppose to same rank for the same value.... check out the arguments for Rank here

[samnoor_27]

Ah ok, now I get it. Thanks a lot for this explanation!