report to automatically show customers that opened the most tickets | Community
Skip to main content

report to automatically show customers that opened the most tickets

  • August 10, 2023
  • 3 replies
  • 0 views
O

I created a report that shows number of tickets created per customer in previous month.

The idea is to show the customers who opened to most tickets, however I need to manually select the customers in the requester organization name, which means I need to know in advance who are the customers I want to display. 

Is there a way to create the report that automatically shows the customers that opened the most tickets (and the number of tickets). For example the 5 customers that opened the most tickets?

    3 replies

    Zendesk13
    • Zendesk13
    • August 10, 2023

    Hi @ofer12, just to note that the report seen in the image shows the # tickets per Requester organization, not Requester.

    To obtain something like "the 5 customers that opened the most tickets", we can use a top/bottom filter. In your report (go to Result manipulation ยป Top/bottom).

    An example:

     

    O
    • Ofer12
    • Author
    • August 13, 2023

    Thanks for this Pedro. I did want to display the tickets per customer organization , not specific requestor, and your suggestion was what I was looking for. Thanks a lot.

    Zendesk13
    • Zendesk13
    • August 25, 2023

    Great news! You're welcome, always happy to help ๐Ÿ‘‹

    Terms & ConditionsCookie settingsAccessibility statement