Recent searches
No recent searches
Filtering for follow-up tickets
Answered
Posted Feb 26, 2019
Sometimes customers rewrite us when the ticket was closed and it creates a follow-up ticket.
In some cases, it's about a different issue and custom fields are changed but in other cases, it's about the same issue, so I would like to exclude those follow-up tickets in my metrics.
There is an existing post for Insight (https://support.zendesk.com/hc/en-us/articles/115004378388-Insights-recipe-Filtering-for-follow-up-tickets) but I didn't manage to get it to work on Explore...
0
4
4 comments
Molly VS
Hey Chloe,
Welcome to The Community! To filter for reopens in Explore, you can use the Reopens Bracket and exclude or include the number of reopens as per your preference:
0
Pedro Rodrigues
The reply above is a bit misleading... Reopens seems to refer to Solved tickets whose update reopens them, i.e. their status changes to Open (source article; "Reopened Tickets: The percentage of reopened tickets that were previously marked as Solved.")
One way of reporting on follow-up tickets, for example:
To report on follow-up tickets, you now have the tag 'ticket_followup'.
(Instead of a tag, you could have a checkbox or some other field, of course.)
0
Violeta Micu
Hello,
There are 2 ways to see the Follow up tickets in explore.
Dataset: Ticket Events
1. This solution helps you to see quickly how many follow-up tickets you have:
Metrics: Tickets created
Filters: Update channel
Attribute Values: Closed Ticket
2. This one will help you to have one defined metric for follow up tickets. In this case you would be able to add other metrics to compare, like total created tickets :)
Define Standard calculated metric:
IF ([Changes - Field name]="status" AND [Changes - Previous value]=NULL)
AND [Update channel]="Closed Ticket"
THEN [Update ID]
ENDIF
After creating the metric you will use COUNT instead of SUM
I compared the data with the one from Insights and it seems correct.
Happy reporting!
Vio
0
Pedro Rodrigues
Awesome, thanks Violeta!
0