Explore recipe: Tickets unsolved for more than three days

Return to top


  • Devan - Community Manager
    Zendesk Community Manager

    Hello @...,

    I reached out to our in-house experts on this, and right now, there is no native way to accomplish this in Explore. I'm going to share this in our weekly digest and see if anyone has a workaround that could help with building this report. 

    Best regards. 

  • Mary SK

    I am very new to Zendesk. Can someone please help me create something for tickets that have had open status for more than 5 days?

  • Brandon Tidd
    Community Moderator
    The Humblident Award - 2021

    Hi @...,

    Welcome to Zendesk!  There's a couple of ways to approach this.  In Explore, you could leverage a similar set of metrics to give you a leading indicator of Tickets that are going stale, but it's not foolproof.  By choosing SUM(Unsolved Tickets Age (days)) and SUM(Unsolved tickets time since update (days)) as your Metrics, The Ticket ID Attribute as your Row and filtering on Ticket Status (Open), you can get a quick table of the current aging of all of your open tickets.  To take it a step further, you can use a Metric Filter to only show wherein the metrics are greater than 5.  See Below:

    > Hint: Right Click And Open Image In A New Tab For A Better View!

    You can also sort by these columns in Ascending or descending order.   

    Note: This is only showing you tickets that are currently open that were created and/or updated more than 5 days ago.  For more detailed tracking, you might consider using an SLA Policy.

    Hope this helps!

    Brandon Tidd
    729 Solutions

  • Carrot

    Hi there. I'm looking to create a bar chart that displays the percentage of on-hold tickets that have not had an agent publicly respond within 0-7 days and > 7 days of the agent's last public response. Is this something anyone can help me with? Thanks!


Please sign in to leave a comment.

Powered by Zendesk