Show tickets not updated for the last month - Explorer | Community
Skip to main content

Show tickets not updated for the last month - Explorer

  • June 1, 2021
  • 2 replies
  • 0 views
M

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?

    2 replies

    C
    • Chandra13
    • June 2, 2021

    1261836946050 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:

    M

    Hi @Chandra Robrock

    Many thanks for your help on this! it works perfectly :) 

    Terms & ConditionsCookie settingsAccessibility statement