Show tickets not updated for the last month - Explorer
AnsweredI 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?
-
@... 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:
-
Hi @...
Many thanks for your help on this! it works perfectly :)
Please sign in to leave a comment.
2 Comments