About the open status report
How do I set up a report to know how many tickets are in an open state for more than 24 hours each month?
-
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
ENDIFIf 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.
Iniciar sesión para dejar un comentario.
1 Comentarios