Canonical Calendar to calculate Outstanding tickets

[Anonymous]

Hi

I have used a canonical calendar to link to the Date Raised and Date Resolved fields in my extract as below. I have attached my script.

Besides the Created and Resolved tickets I need to calculate the Outstanding tickets.

Outstanding tickets are all tickets with Status ='Open'.

I have used the Weekstart for the X axis and use the following expression count(DISTINCT{<Status={'Open'},[Referred to CPS]={'Y'}>}[TR #]) . Essentially it needs to show all tickets that are having status ='Open' even if there is a resolved date for all successive weeks until the Status is changed to Closed as of date. so if a ticket has a Open status that was created in 2015 it needs to reflect in the weekstart of 13 Oct 2016.

Issue that I am facing is that ticket is reflected only in the week that it has been created and in the week that it has been resolved. It is not being considered in the missing weeks between  the 2 dates nor in subsequent weeks after the resolved date until today's date.