Show "ranking" numbers in table?
RespondidaHello,
I have a number of table reports which show things like "the Top 20 busiest days of all time" or "the Top 10 most tickets solved by a single agent in a single day".
What I want to know is; is there a way to list the "rank" for each of the rows in these tables? Essentially I want a column that is just the numbers 1-10 (or 1-20 or whatever) to make it easier to see that today was the 7th busiest of all time, for example.
So, mocking up a fake table in Excel, it'd look something like this:
Any suggestions for how to get that "Rank" column?
-
Hey Terry!
Check out the Rank option under Result Manipulation > Result Path Calculation
-
I'm sure I'm being dumb, but that's replacing the ticket count with the numbers 1-20. Do I need to add another metric to change to this? I'd like to keep the ticket count too.
-
Another option might be to "show row number" in the column configuration. If your metric values are sorted, then that works to show the "rank".
-
💯 What @Hilary Latham said
-
Hooray! +1000 Zendesk points to Hilary!
Thanks very much to both of you!
Iniciar sesión para dejar un comentario.
5 Comentarios