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!