Explore recipe: Percentage of tickets created by channel

Return to top

3 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

Please sign in to leave a comment.

Powered by Zendesk