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.
A column for Ticket IDs per agent
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.
Thank you very much, that made me rethink how I would need to go about creating the tables.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.