Top 3

[kalpana]

Numbers - no of tickets resolved

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

[DAX0110]

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]

No , i want in the format which i attached.

Tower  Top1 Top2 Top3

DB 

Linux  

[kalpana]

I am having data like this.

How i want is

Tower Top1           Top2               Top3

DB   Johsnon 213

Linux

[DAX0110]

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

[kalpana]

then we have to look at 4th person.

[kalpana]

But in the image, they belongs to different teams