A column for Ticket IDs per agent | The place for Zendesk users to come together and share
Skip to main content
Sigmund
Sigmund
July 27, 2021
Question

A column for Ticket IDs per agent

  • July 27, 2021
  • 2 replies
  • 31 views

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.

      2 replies

      ZZ59
      ZZ59
      July 27, 2021

      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.

       

        Sigmund
        SigmundAuthor
        July 28, 2021

        Thank you very much, that made me rethink how I would need to go about creating the tables.

        Terms & ConditionsAccessibility statement