Explore recipe: Tickets unsolved for more than three days

Have more questions? Submit a request

15 Comments

  • Kristina Fronheiser
    Comment actions Permalink

    This query is no longer working in Explore. 

    0
  • Ricardo
    Comment actions Permalink

    Hello, Kristina,

    Which step exactly are you having issues with? I just recreated the query in my test account and on my side it is working fine.

    0
  • Kristina Fronheiser
    Comment actions Permalink

    I am getting an error with syntax. Any ideas?

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hey Kristina,

    It's possible you're not using the correct dataset which is why you're seeing this error. Can you confirm you're using the Support>Tickets>Support: Tickets dataset when creating this metric?

    Let me know!

    0
  • Kristina Fronheiser
    Comment actions Permalink

    That worked! 

    Separate question, is there a way to track tickets that have not been touched in x number of days? I mean any update at all.

    0
  • Kristina Fronheiser
    Comment actions Permalink

    I just need to count the number of tickets that meet the criteria of 'not touched in >7 days" per agent.

    0
  • Devan
    Comment actions Permalink

    Hello Kristina Fronheiser,

    So there is a "last update date" attribute you can use to accomplish this. You can use this attribute to either filter the query, or use it in a standard calculated metric. 

    Best regards. 

    0
  • Kristina Fronheiser
    Comment actions Permalink

    I think I got it, but I'm hoping you can confirm my logic makes sense!

    IF ([Ticket status - Unsorted] != "Solved" AND [Ticket status - Unsorted] != "Closed") AND
    (DATE_DIFF(NOW(), [Ticket updated - Timestamp], "nb_of_days") > "7")
    THEN [Ticket ID]
    ENDIF

     

    0
  • Devan
    Comment actions Permalink

    Hey Kristina Fronheiser,

    Everything looks great on our end, excellent job! Let us know if there is anything else you have a question on, but again, great job on crushing this formula, your logic 100% makes sense.

    Best regards. 

    0
  • Kristina Fronheiser
    Comment actions Permalink

    One last question (I hope!)

    I've got the following query that's looking at anything that hasn't been touched for more than 14 days. However, it did not return a result. It's blank, no 0 displayed. I tried un-clicking the metric setting to show blank values, but it didn't work. How do I get it to show a 0 when it doesn't return a record?

     

    My query is: 

    Dashboard:

    0
  • Devan
    Comment actions Permalink

    Hello Kristina Fronheiser,

    This article goes into detail on how to include a 0 value in explore reports. Let us know if this helps resolve this error for you, and if there is anything else we can help with, please don't hesitate to ask. 

    Best regards. 

    0
  • Jim Collins
    Comment actions Permalink

    I followed these instructions to a tee, and the report doesn't resemble what is shown. 

    0
  • Devan
    Comment actions Permalink

    Hello Jim Collins,

    So I think you may have the wrong type of graph as well as having not enough dates selected from the image you shared with us. I would recommend still starting with a row chart just in the initial setup and ensuring you have the "Ticket Created - Date" selected. Go ahead and run a check on what I mentioned and let me know if you are still having this issue. 

    Best regards. 

    0
  • Robert Magee
    Comment actions Permalink

    Hi,

    Kristina Fronheiser has setup a dashboard called Zendesk Ticket reporting and has posted a picture of it 4 months ago. I am new to Zendesk and would love to get something setup like this for my teams. How would I go about this?

    Kind Regards

    0
  • Brandon Tidd
    Comment actions Permalink

    Hi Robert Magee 

    Happy to try and help here.  This dashboard looks like it is leveraging several queries and some custom dashboard formatting.  The linked articles should set you on the proper course... And speaking of courses, I would highly recommend checking out some of the training resources available via the learning portal.

    Brandon

    0

Please sign in to leave a comment.

Powered by Zendesk