• Chris Bulin

  • 17. März 2021 15:21

  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!

• bill cicchetti

  • 28. April 2022 15:22
  • Bearbeitet

  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?

• Gab Guinto

  • 29. April 2022 12:07

  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.
  
• bill cicchetti

  • 29. April 2022 15:41

  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?

• Gab Guinto

  • 2. Mai 2022 01:27

  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!
  
• John DiGregorio

  • 30. August 2022 17:36

  What was the outcome of this thread.   I am looking for a simple report that shows the date the ticket was last created and the time it was last updated with a public comment.   I have the report setup but it is showing the date of each public comment, I just want the last one.

  Thanks

  JD

• Gab Guinto

  • 6. September 2022 04:04

  Zendesk Customer Care

  Hi John,
   
  You can use the latest date functions to pull up the most recent public reply on a ticket. You can refer to this doc about Working with earliest and latest date functions, specifically the sample recipe for date_last_fix. 
  
• Dave Symonds

  • 16. November 2022 22:04
  • Bearbeitet

  Question - you have used the ticket updated date.  Would that not mean that the selection would be based on any field updated not necessarily the date the agent replied?

  This seems to imply that the last update was the public comment?  What am I missing here - what's the relationship between last updated and the time that the comment was made on the ticket?

   

• Gab Guinto

  • 30. November 2022 07:05

  Zendesk Customer Care

  Hi Dave,
  
  Yes, that's right, in the sample above, the data is sliced by when the last update was made on the ticket, not necessarily the comment timestamp. If you need the exact timestamp of the last agent comment, then you may have to create your report under the Updates history dataset, with custom attributes or metrics built using the latest date functions. You can check out this article to see some sample recipes: Working with earliest and latest date functions.
  

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.