Ticket Backlog - Filtering by Ticket Age
Hey all
I made a backlog report that shows me how many tickets we had open at the end of each 1 week period:
Metric: SUM(Tickets)
Column: End of week (Sun-Sat)
Filter: Backlog recorded - Date (12 weeks in the past to 1 weeks in the past)
In my Organization, we consider to Backlog to be the number of aging tickets at the end of each period. I would like to create a report just like this, but have it only account for the tickets that were open at the beginning of the period.
I want it to show the number of tickets that were open at the beginning of the period that were still open at the end of the period. If a ticket was created during the period, I would like it to be ignored from this report.
The options we are given in the Backlog dataset seem to be very limited, but I'm hoping somebody has a solution to my problem and I'm hoping I'm just missing something simple :)
Thanks in advance!
-
Chris Curlett Have you been able to figure this out? Similarly, I consider a backlog ticket that's older than X days, but I didn't see a way to filter by either date a ticket was created or by age.
-
Hey Allen,
If you are using the tickets dataset you should have a metric for Unsolved Tickets Age and then you can use the metric filter to filter for tickets older than x days.
Let me know if you have any further questions.
Please sign in to leave a comment.
2 Comments