Counting Tickets Changed from New to Solved, Filtered by Tag



  • Oliver Knigge


    I think you have to create separate metrics for every single tag to report or filter on specific tags. Refering to this article:

    The metrics should look like this:

    SELECT IFNULL((SELECT # Tickets WHERE Ticket Tag = your_tag),0)

    (Replace your_tag with the tag you want to use in the report.)

    Then you can use these metrics combining AND/OR like this:

    ....SELECT COUNT...... WHERE ... AND ... AND ... AND ((SELECT #METRIC1 BY Ticket Id)=1 OR (SELECT # METRIC2 BY Ticket Id)=1 OR (SELECT # METRIC3 BY Ticket Id)=1).


  • Jude

    Many thanks Oliver, that cracked it for me.

  • Amy Dee
    Zendesk team member

    Hi Jude! Oliver sent you to the right place - that's definitely the approach you'll need.

    Since you're interested in tickets that have at least one of a large list of tags, you could combine them in your tag filtering metric - SELECT IFNULL((SELECT # Tickets WHERE Ticket Tag IN (listoftags)), 0)

    This would allow you to see tickets that had any one of the listed tags, or tickets that have none of the listed tags. You only need to stack separate filtering metrics if you need to see tickets that have all of the tags on your list.

    I hope this helps! Happy reporting!

  • Jude

    Thanks Amy, you're quite right and that's exactly what I did in the end, learned from a previous comment of yours that helped me :-)


  • Sheryl Fontanilla

    Do we have a recipe for Explore? I need to extract the ticket count from pending to solved status

  • Brett Bowser
    Zendesk Community Team

    Hey Sheryl,

    Can you try the metric formula mentioned by Nhia in this comment: Recipe required for ticket status changes

    I believe that should get you the results you're looking for.



Please sign in to leave a comment.

Powered by Zendesk