Need total items open at end of each month (including historical)
I am having difficulty thinking this one through
I have item records that are submitted into the system and then sit there until they are assigned. I have a flag that indicates if it has been assigned and I capture the date that it was assigned. I also have the submitted date.
What I need is a line chart showing the total number of items that were not assigned at the end of each month.
If submitted and assigned in the same month it does not get counted.
If submitted in Jan. and not assigned until Feb. it should count as 1 in Jan and 0 in Feb.
If submitted in Jan and not assigned until March it should count as 1 in Jan and 1 in Feb and 0 in March.