Explore: How many solved tickets have more than two public comments by agent | Community
Skip to main content

Explore: How many solved tickets have more than two public comments by agent

  • December 14, 2022
  • 2 replies
  • 0 views

Kirk13

Hi, 

We would like to know the number of solved tickets have more than two public comments by agent in Zendesk Explore, but not sure how to set this report up.

Thank you.

 

 

2 replies

Kirk13
  • Author
  • December 14, 2022

I can find out the tickets which have more than 2 public comments and listed, but not east to see the total number of tickets have more than 2 public comments for each agent. We don't know how to do the count in Explore


  • December 22, 2022
Hi Kirk,

You can try creating the report with the Tickets dataset and then reference the default metric Agent replies in your custom metric formula. Example:
- IF VALUE(Agent replies) >2 THEN [Ticket ID] ENDIF -
This should return the count of tickets with more than two public agent comments.