About the open status report | Community
Skip to main content

About the open status report

  • May 1, 2023
  • 1 reply
  • 0 views
Tagui

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
    • 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 & ConditionsCookie settingsAccessibility statement