Recent searches
No recent searches
Is there a report metric that counts solved tickets excluding child tickets?
Posted Jun 28, 2024
Hello,
As part of the onboarding process for new hires, we create onboarding tickets that include up to 5 child tickets each. The child tickets are assigned to other departments and they solve them out individually. I would like to create a report of the onboarding tickets assigned to (and solved by) just my department, but when I put in the metric “Solved tickets” it counts the parent and child tickets. I can't figure out how to build a metric for a report that excludes child tickets. Is this possible?
Hope this makes sense. Your advice is appreciated!
Thanks!
0
2
2 comments
Davor Japunčić
Hey, yeah, you can give this a shot!
Please make sure you read this article: https://support.zendesk.com/hc/en-us/articles/4408836190362-Writing-Explore-formulas
Define the Custom Metric: Use or customize the following formula to exclude incident tickets and only count solved parent tickets:
IF ([Ticket type] != "Incident" AND [Status] = "Solved") THEN [Ticket ID] ENDIF
Best of luck!
0
Rita Johnston
Thank you so much, Davor! I'll give it a try : )
1