This Explore Recipe allows us to report created and solved tickets (https://support.zendesk.com/hc/en-us/articles/4408825110682) however we need to report ticket closed in a given period. How can we report number of ticket with status set to closed in a given period (last week, last month etc)?
Reporting Closed Tickets
Hello Judy,
First, you can create an metric that would return the number of tickets that were set to Closed status. This can be achieved in the Updates dataset. Here's how the formula should look like:
IF ([Changes - Field name]="status" AND [Changes - New value]="closed")
THEN [Ticket ID]/[Ticket ID]
ENDIFOnce you have this created, you can use the Update - Date attribute that should return the date when the ticket status was set to "Closed".
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
First, you can create an metric that would return the number of tickets that were set to Closed status. This can be achieved in the Updates dataset. Here's how the formula should look like:
Once you have this created, you can use the Update - Date attribute that should return the date when the ticket status was set to "Closed".