Reporting on end-users with multiple requests of the same type



  • Gab Guinto
    Zendesk Customer Care
    Hi Greg,

    Here's a different approach:
    You can start by creating a custom attribute to identify the request type based on tags. Example:
    IF (INCLUDES_ANY([Ticket tags], "ticket_type_1")) THEN "Type 1"
    ELIF (INCLUDES_ANY([Ticket tags], "ticket_type_1")) THEN "Type 2"
    ELIF ...
    With the native Tickets metric, you can add this custom attribute under Rows to see a breakdown of tickets per request tag. You can then add Requester name to slice the data further by requester.
    Then, apply a metric filter to only show rows with a ticket count of 0 to 4. Your table should display requesters with 4 or less ticket per each request type. 
    Hope this helps. Thanks Greg!
  • Greg Choisser

    This worked perfectly!


Please sign in to leave a comment.

Powered by Zendesk