Explore recipe: Backlog tickets by month

Return to top

5 Comments

  • Mirek Kokeš

    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.

    Mirek

    0
  • Marcus Spedding

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

    As soon 

     

    0
  • 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. 

    1
  • Marcus Spedding

    Thanks. 

    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. 

    Thanks

    0
  • 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. 

    0

Please sign in to leave a comment.

Powered by Zendesk