Explore recipe: Percentage of tickets created by channel

Return to top

5 Comments

  • Richard Ly

    Great article and exactly what we were looking for. We were able to use this to show the number and percentage of total tickets in the same table.

    Thanks for the write-up.

    1
  • Jon Durlauf

    How would you adapt this query for a multi-select ticket field?

    I am trying to create a report showing the percentage of tickets that include different topics. The topics are selected via a multi-select ticket field, so a single ticket can have multiple topics.

    Following this recipe, I was able to show the correct counts for each topic. However, the percentages are incorrect. The example below is reporting on 3 total tickets, so the percentages in the table should be 67% and 33%. Any ideas how to correct this?

     

    0
  • Elaine
    Zendesk Customer Care

    Hi Jon,

    I understand that you want to report on the percentage of tickets that have multiple topics chosen with the use of a multi-select ticket field.

    Due to the way multi-select ticket fields are stored, a ticket with multiple topics/values chosen will always be returned multiple times throughout a query may it be a count of tickets for each topic or based on its percentages. There’s not a way to only count a ticket once across all multi-select values.

    Hope I was able to clear this one out. :)

    0
  • Suhan Li

    Can someone help me to figure out how the percentage of the sub-item's count, e.g., I count tickets for each agent's response time and separated it as =< 3 days and > 3 days. I got the number of tickets out. Now I want to know what is the percentage for =< 3 days. But I have trouble with this. I know the formula should be count(=< 3 days)/count(Tickets). I tried all ways without any results.

    Thanks,

    0
  • Dave Dyson
    Zendesk Community Manager
    Hi Suhan! It sounds like you've built a custom metric, so I'd think that the recipe in the above article should work -- you'd just select your custom metric in Step 5. Have you tried that?
    0

Please sign in to leave a comment.

Powered by Zendesk