Explore: How many solved tickets have more than two public comments by agent | The place for Zendesk users to come together and share
Skip to main content
Kirk13
Kirk13
December 14, 2022
Question

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

  • December 14, 2022
  • 2 replies
  • 22 views

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
    Kirk13Author
    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

    G
    Gab12Employee
    Employee
    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. 
    Terms & ConditionsAccessibility statement