Forum Discussion

kalpana's avatar
kalpana
Icon for Helper I rankHelper I
8 years ago

Top 3

Numbers - no of tickets resolved   I want top 3 perfomers in this format. Is this possible?  
Need Help
DAX0110's avatar
DAX0110
Icon for Resolver V rankResolver V
8 years ago

Yes it's possible.

 

Use the Query Editor to:

1. unpivot the "top N" columns

2. split the "name, count" column into two columns

3. then you can calculate overall top 3 using the "count" column

 

 

  • kalpana's avatar
    kalpana
    Icon for Helper I rankHelper I
    8 years ago

    No , i want in the format which i attached.

     

    Tower  Top1 Top2 Top3

    DB 

    Linux  

    • kalpana's avatar
      kalpana
      Icon for Helper I rankHelper I
      8 years ago

      I am having data like this.

      How i want is

      Tower Top1           Top2               Top3

      DB   Johsnon 213

      Linux

      • DAX0110's avatar
        DAX0110
        Icon for Resolver V rankResolver V
        8 years ago

        How do you deal with "ties"?  ie if two persons are ranked equal-third, which one do you choose as the "Top 3"?