Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MRitter
Employee
Employee

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.

And so on.  

Thanks

Labels (1)
0 Replies