Recent searches
No recent searches
A column for Ticket IDs per agent
Answered
Posted Jul 27, 2021
I work with the QA team and would need a way to quickly drill down individual ticket IDs on an agent level. I would usually look at it on a very small date range so I don't expect large volumes to be a problem but all I want is one column for agent names or IDs and another one for actual ticket IDs. The queries I can see require a Metric on which to summarize the data but I do not need a summary of the data, just individual ticket IDs I can use as a raw data file.
1
2
2 comments
ZZ Graeme Carmichael
Sigmund
All queries require a metric included as an output. Even if it is just COUNT(Ticket ID) you need to include something.
If you really do not want to see that metric on your output, you can go to Chart Configuration>Columns and then hide the column that the metric appears on:
For example, in the above, if the third column has your metric, it will not be shown.
1
Sigmund Domingo
Thank you very much, that made me rethink how I would need to go about creating the tables.
0