"Tickets created in the last 90 days" query

5 Comentários

  • Comentário oficial
    Rob Stack
    Zendesk Documentation Team

    Hi Sergiu Captari thanks for the question. There's a pre-built report that does exactly what you need on the Support dashboard. You can adjust the date filter on this report to limit it to the last 90 days.

    For more details, see https://support.zendesk.com/hc/en-us/articles/360022367893

    I hope this helps. Thanks!

  • Sergiu Captari

    Thanks for your answer, Rob!

    I'm actually trying to build a custom report that would show a list of backlog tickets that were created in the last 90 days. For the moment, the only option I see is to include all the tickets in the query. 

    0
  • Chris Bulin
    Community Moderator

    Hi Sergiu Captari! If you are using the Backlog dataset, you can use the Backlog Date recorded and the Advanced date settings to do this. FIlter>Backlog Recorded - Date>Edit Date Settings>Advanced

    Here's what the filter would look like:

    0
  • Sergiu Captari

    Hi Chris,

    this is how my chart looks now:

     

    At the moment, it shows all the tickets that are in the backlog, for the last 30 days, regardless of the date they have been created. I need to add a filter that would only show the tickets created in the last 90 days.

    0
  • Chris Bulin
    Community Moderator

    Hi again Sergiu! I see what you mean. I reviewed the documentation and there is not a specific metric or attributed related to tickets created, but I think there may be a couple of proxies for this. 

    You could look at tickets with only the New status for your 90 day time period. However, this may not work if you are receiving tickets heavily in Open status by assigning them directly to one person, for example.

    The other option, which would need time to run, would be to set a specific type to the ticket and then create an automation that updates the type at the 90 day mark. Then you could filter this query by that ticket type.

    The backlog dataset is rather limited in it's options for slicing content compared to the other datasets.

    0

Por favor, entrar para comentar.

Powered by Zendesk