Explore recipe: Backlog tickets by month

Return to top


  • Mirek Kokes

    Hi there,

    I would like to know how can I get a monthly backlog of tickets for a certain organization? I want to show that each month we were able to lower the backlog of tickets and that we improved in this area. However, I wasn't able to figure out the correct setting. Is it even possible with the current Explore features? If not, where can I upvote the idea?

    Thank you.


  • Marcus Spedding (SC)

    This doesn't work. it's displaying MILLIONS of tickets. We only have 17, 000 in total. 

    As soon 


  • Matt

    Hi @...
    Unfortunately there is currently no way to report on Organisations from the Backlog History Dataset. There is also some more information on this here: 
    Why can't I see most of the attributes when reporting on Backlog Tickets in Explore?

    Feel free to create a Feedback Post about this here: Feedback on Explore
    To workaround this, you might need to create a report in a different Dataset, such as the Tickets Dataset using the Metric Unsolved Tickets. 

    I hope this helps answer your question. 

    Hi @...
    This might occur because the Metric aggregates the SUM of all your unsolved Tickets.
    To measure how many backlog tickets were recorded at the end of the month/year, you can use the Backlog end of period attribute. Then make sure to exclude the values for "NULL" in that attribute. 

    Feel free to look at What is the difference between Backlog recorded and Backlog end of period? for more information on the attributes.

    Let us know if this still does not help you get the result you are hoping to see. 

  • Marcus Spedding (SC)


    How can this be set up to show a series of results across two years (for example April 2020 to April 2021)?

    With the setup as above, there are different graphs by years. I'd like all this information in a single year. 


  • Mark Leci

    @... I prefer to run this report using the dates in the columns instead of rows. That should combine all the info into a single graph for you. 

  • MAD Monica Maldonado

    I am missing filters in this data set so I cant know how many unsolved specific kind of tickets i had in a past date as I dont have for instance the ticket form filter. This is a big missing for us.

  • Gab Guinto
    Zendesk Customer Care
    Hi Monica,
    The team is working on to add more attributes to the Backlog dataset in Explore, and per the Product Manager, this includes the attribute for Ticket form. There's no definite timeline yet for this, but you can check out this thread with a pinned post from Product. You can also follow that post to get notified when there's a new update on this.
  • Gustavo Parra

    The Backlog History dataset is useless due limited attributes available.  


Please sign in to leave a comment.

Powered by Zendesk