I made a backlog report that shows me how many tickets we had open at the end of each 1 week period:
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!
Please sign in to leave a comment.