I am trying to create a report that shows time between a new ticket created to resolution (solved) for a specific group of people and categories.
I want to calculate this time up to ticket status Solved and exclude time between Solved and Closed as we have a 30-day window between Solved and Closed, causing the numbers to be highly inflated.
Is there a way to do this?
I copy and pasted this same thing and it errors out for me.
EDIT:
There might have been a typo from the screenshot to the attribute posted. It's actually:
DATE_DIFF([Ticket solved - Timestamp], [Ticket created - Timestamp], "nbof_minutes")
I feel like i did something wrong here because that attribute isn't giving me values and errors out on the bottom of the page what when clicked on shows:
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
An easy way to calculate that is to use the Ticket Updates dataset instead of the Support Ticket Default. You can then compare the time from when the ticket was created to when the status was updated as solved.
To have the exact result, you can create a calculated attribute that will give you the exact number of minute from the ticket creation to the last time it was updated as solved (not including the time between solve and close) :
DATEDIFF([Ticket solved - Timestamp], [Ticket created - Timestamp], "nbof_minutes")I hope this helps,
Best,