Recent searches
No recent searches
Show tickets not updated for the last month - Explorer
Answered
Posted Jun 01, 2021
I am trying to create a query in which:
- show me those tickets that are open and there has been no update in the last 3-4 weeks.
I am trying to apply a date filter, to exclude them, but it only shows me those that have had updates.
Does anyone know how to create it?
0
2
2 comments
Chandra Robrock
@... Taking a look at my own Zendesk instance, I think this recipe might work for you.
Dataset: Ticket Updates
Metric: I created a Standard Calculated Metric called Count(Tickets) to mimic the Tickets metric in the Tickets dataset. The formula for this metric is simply [Ticket ID]
Filters:
Ticket Status is Open
Ticket Updated - Date - I selected the Advanced Options to adjust this date filter as follows:
0
Margarita Obrador Almodóvar
Hi @...
Many thanks for your help on this! it works perfectly :)
0