About the open status report | The place for Zendesk users to come together and share
Skip to main content
Tagui
Tagui
May 1, 2023
Question

About the open status report

  • May 1, 2023
  • 1 reply
  • 41 views

How do I set up a report to know how many tickets are in an open state for more than 24 hours each month?

    1 reply

    Zendesk13
    Zendesk13
    Newcomer
    May 2, 2023

    Hi @tagui, check this Explore recipe for Calculating the average time a ticket is in each status through its lifecycle. Additionally, you can also create a standard calculated attribute like the following, for example:

    IF AVG(Open status time (hrs)) > 24
    THEN [Ticket ID]
    ELSE NULL
    ENDIF

    If you then add this attribute to your report and exclude NULL values, you'll have all the ticket IDs where the Open status time exceeded 24 hours.

    In parallel to the Explore report, I'd also suggest creating an automation to tag tickets whenever time since pending is greater than 24 hours (or 23 hours, depending on how you prefer to have it and because of automation execution times). Especially if you'd like to identify those tickets in order to follow up on them in any way within Support.

    For more information on this, make sure to check Using the "Hours since" condition in automations and Understanding when automations run.

    Terms & ConditionsAccessibility statement