Zendesk Explore - Last public reply by an agent against each ticket

Answered

5 Comments

  • Chris Bulin
    Community Moderator

    Hi Kenny Li! You can get this from the Support: Ticket Updates dataset. I've created an example that can give you an idea of how to get to it. I measured Agent Replies, filtered it to This Week, and then added the date of update, Ticket ID, and Assignee Name:

    Hope that helps!

    0
  • Bill Cicchetti

    Hi I am trying to create a report similar to the request above. "Report on the date of the last public reply by an agent". In the suggestion above I don't see where it is restricting to the update being a public comment.  Any suggestions?

    0
  • Gab Guinto
    Zendesk Customer Care
    Hi Bill,
     
    If you want to build a similar table, you can create your query under the Updates history dataset, and use the Public comments metric. You can then filter your report by Updater role and select Admin and Agent. Under rows, you can add the attributes Ticket ID, Update - Date and Updater name (in that order). The table will most likely show rows with zero values under the Public comments metric column. Just apply a metric filter to hide zero results (Selecting the metric result range). 
     
    Alternatively, if you're comfortable with custom reporting and building calculated attributes, you can try using the latest date functions. Here's an article talking about these date functions: Working with earliest and latest date functions. The example in that doc uses DATE_LAST_FIX to find the timestamps of the latest agent comment. Since you're looking to slice you data by Ticket ID, you can try replacing [Updater name] in that sample formula with [Ticket ID]. You can read through that article to learn more about the earliest/latest date functions.
    0
  • Bill Cicchetti

    Thanks Gab,

    I was able to capture the info I wanted with some additional modifications.

    IF ([Comment present]=TRUE 
    AND [Comment public]=TRUE 
    AND DATE_LAST_FIX([Update - Date],[Comment present],[Comment public],[Ticket ID])=[Update - Date]) 
    THEN [Update - Date] ENDIF

    My next question is I am looking for any date that's > 21 days.  I tried the following but it didn't provide me any results  DATE_DIFF,Today(),<custom attribute>,"nb_of_days")  To get the days since last update but it did not return any data (code was accepted with a green checkmark).

    Suggestions?

    0
  • Gab Guinto
    Zendesk Customer Care
    Hi Bill,
     
    Let me create a ticket so that we can troubleshoot this further. You'll receive an email on this shortly. Thanks!
    0

Please sign in to leave a comment.

Powered by Zendesk