Forum Discussion

kalpana's avatar
kalpana
Helper I
8 years ago

Top 3

Numbers - no of tickets resolved

 

I want top 3 perfomers in this format. Is this possible?

 

Need Help

6 Replies

  • DAX0110's avatar
    DAX0110
    Resolver 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
      Helper I
      8 years ago

      No , i want in the format which i attached.

       

      Tower  Top1 Top2 Top3

      DB 

      Linux  

      • kalpana's avatar
        kalpana
        Helper I
        8 years ago

        I am having data like this.

        How i want is

        Tower Top1           Top2               Top3

        DB   Johsnon 213

        Linux