Recent searches
No recent searches
Explore - Number of tickets per day from a field value
Posted Oct 31, 2022
Hi,
I need to create a report showing when a ticket has changed a value in a custom field from any other value to a specific value.
I.e Ticket 12345678
Enquiry status = Sales enquiry or Lost contact
The value then changes to
Enquiry status = Sales active
I need to build a report that shows for the last 14 days how many tickets moved to 'Sales active' from any other value.
The team want to know I.e:
Monday: 25 tickets moved to Sales active
Tuesday: 26
Wednesday: 30
Etc...
I've tried several ways to do it and I can't seem to figure it out
Thank you very much in advance for any help given
0
3 comments
Dave Dyson
I think recipe should get you started: Calculating duration of time for custom ticket fields. I think you might want to record the ticket creation date instead of the time the field was updated in the THEN statement.
0
Glen Schneider
Hi Dave,
Thank you for the reply.
The ticket is created into an earlier team that might go through 5 different values for the enquiry status before its moved to this team.
But this team might take weeks to resolve the issue before it is moved to the next team. The tickets are used like a workflow and are not separated for each group.
The team want to know how many tickets got moved to their group per day. Creation wouldn't be useful for this use case, any ideas?
Thank you
0
Gab Guinto
You can try creating a metric that looks at the Ticket field changes attributes. Example, if you need to count the instances where the value on "Your custom field" was changed to "Sales active":
You can filter the report by Update - Date if you need to limit the results to a certain period; if you slice the data by Update - Date under Rows/Columns, then you'll see the count of field changes per day.
0