Report on Aged tickets and Backlog report weekly.


  • Jennifer Rowe
    Zendesk Documentation Team

    Ravi, this is awesome! Thanks for sharing it with the community.

  • Szabolcs Szilagyi

    Does somebody know an option how to measure "open" (new, open, on-hold, but NOT in pending state) tickets' age? I mean I would like to create a report about those tickets what are opened longer than 8 business hours by our helpdesk, excluding that time when we are awaiting for customers.

  • Brittany

    Hi Szabolcs Szilagyi!

    You'd want to look at the metric Ticket Age (Open Tickets), which is New, Open, and Hold status. You can also add Ticket ID and Status. GoodData also has an article for this as well (see here).

    To incorporate business hours, you'd want to make an automation that tags tickets 8 hours after creation. Then you can add that to the report.

    You could also build a custom metric to measure this. We're not able to tell you exactly how to do it here in Support, but there are a lot of Insights resources available to you in the community. You can also make a request for that metric here. If enough people comment, we might be able to make a tip of the week!

  • Rico

    Does anyone know of a way to get backlog broken down by product? I've not found a way to do this since "product" is a custom field. 

  • Solène Regnier

    Hello rdimarzio,

    You can actually create reports based on custom fields. There are imported as different objects in GoodData depending on their types. For more details about that you can check the following article: 

    I hope that helps!


  • Rico


    Thank you for the input, but I have to admit, I'm understanding how to use this data. If opening a support ticket is the correct way to get help on this subject, I'd be happy to do so. 

  • Karyn Tooke

    Is it possible to generate a report that shows the age of a ticket at a point in time such as daily, weekly or monthly?

  • Andrei


    I've looked further into that workflow and unfortunately that would be quite difficult to implement. The problem here is that the backlog report is in a completely different section in the data model than where the custom field that you created would be. So while we can create reports on custom ticket fields and reports on backlog data, getting the two to work together would not be possible at this time.


    Reports are updated when a specific event happens or actions the ticket, until that point no data is written. So unfortunately your ideal report would not be possible to create. The limitation of Good Data is that it does keep running totals of any specific metrics. Specifically with the ticket age metric changing the ticket status for example should update the event in question.

  • Eshmeet Singh

    Current ticket aging report throws result in calendar days, could you please help me create the same report in business days?



  • Jessie Schutz
    Zendesk team member

    Hi Eshmeet!

    If you look in the Backlog Week on Week section of this article and go to step 3, you'll see a screen shot of what building this report looks like.

    Click where it says Click to select specific values, and choose the days you want included in the report. That should take care of it!

  • Christopher J. Crocker


    I've search in Zendesk comunities, KB, and in GoodData MAQL doc.   I am struggling to find an answer to this question...

    I am using the following MAQL statement:

    SELECT # Unsolved Tickets WHERE ( SELECT Ticket Age (Days) [AVG] BY Ticket Id ) between 30 and 60

    Does the "between" act as an inclusive here?  Meaning will I return a count of the tickets that are aged 30 to 60 days "inclusive"?  or will this return starting at age 31 days to 59 days?

    If the MAQL "between" is not inclusive, is there an alternate MAQL clause/syntax that would be inclusive?  or do I simply change my statement to be between 29 and 61 ? 

  • Billy Macken

    Hi Chris,

    I can confirm, when using BETWEEN, the two date range end points are inclusive:  

    I hope this helps! Happy reporting!

  • Kriti Anand

    Hi Guys, I had just one question, while running the code provided, I am getting Unknown object (uri: AVG). Could you please help me here

  • Christopher J. Crocker

    Hi Kriti,

    Are you using the metric in Zendesk Insights?

    AVG is in the name of the metric used for this.


  • Heather Lange-Wilson

    Jessie - 

    You refer to a screenshot under step 3 of Backlog week by week, however I am not seeing any screenshot.

  • Jessie Schutz
    Zendesk team member

    Hi Heather!

    Hm, it looks like the image broke since my last comment. This is a Tip generated by one of our community members so I can't guarantee that we'll be able to replace it, but I'll try!

  • Chase Redfield

    @ Jessie

    I am also running into the same issue with the missing screenshot! Any help you can provide would be great as currently I am showing the screen below but I assume that the filter will get around this. 


    Even if we don't get the screenshot back, knowing what filter to apply should be enough. 



  • Nick LaColla

    The screen shot in #3 of Backlog Week on Week appears to be mission.

  • Jessie Schutz
    Zendesk team member

    Hi everyone!

    I apologize for the inconvenience on this. I'm working finding someone who might be able to help.

    As I mentioned before, this is a Tip written by a Community Member, which means that we don't have access to the original images that they posted. If those images become unavailable for some reason, we don't have a way of retrieving them and we have to rely on other Members to volunteer to re-create the images or the entire tip.

    Be assured that I'm looking into this, and I'll let you know if I come up with a fix.

  • Taimur Saad

    Why was Tickets days Avg was used instead of Ticket days open?



  • Brett Bowser
    Zendesk Community Team

    Hi Taimur,

    The Ticket Age (days) [AVG] metric will look at the average number of days between the ticket created date to the present BY ticket ID WHERE deleted tickets are not included. This will include tickets regardless of status where as Ticket Age (Open Tickets) will not include any tickets in the Deleted, Solved, or Closed statuses.

    If you want to exclude solved tickets from this metric then you can certainly use Ticket Age (Open Tickets) instead.

    Hope this helps!

  • Randy Nieukirk

    If I wanted to create these custom metrics in Zendesk Explore for a query, which Data Set would I use fo rthe query?

    1. Tickets
    2. Ticket Updates
    3. Backlog history


  • Ricardo
    Zendesk Community Team

    Hello Randy Nieukirk

    In the Tickets dataset schema you have a metric called Unsolved tickets age (hrs). If you want to customize the metric then you should do it in that dataset! For more information, see Tickets metrics.


Please sign in to leave a comment.

Powered by Zendesk