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

    Rank Function

    Anjali Ahlawat

      Hi,

       

      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.

      error.PNG

       

      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:

       

      Capture3.PNG