6 Replies Latest reply: Jun 28, 2017 1:42 AM by Ravi Balar RSS

    Rank Function

    Anjali Ahlawat



      I am using rank function on one column and getting the below results:


      The formula used for Rank is :

      =Rank(count({$<[Common Ticket Type]={'INCIDENT'}>} TicketID),4)

      But if you will see below the rank in column 1 should be '3' for value '82' in column 2 but it is coming 12.



      Please let me know if I am doing something wrong.


      Also using these ranks I am storing top 10 resolver groups in variables.


      My requirement is that I want to show the top 10 resolver groups based on the calculation done in column 2 above and show it like A,B,C etc below in descending order: