Count items depending on the date until state of Item Changes
I'm trying to find a way to build a chart and and need your help for this one. I have a very simple set of data :
The chart I want to build is to have the weeks as dimensions and one measure. What I want to measure is:
At each week I want to know the number of ID that are delivered. So I could use rangesum() but then I have my second condition that is not compatible with range sum(). Meaning that as soon as I have for a same ID an Autorized date then from that date this ID shouldn't be counted anymore as Delivered. But It has to show up delivered in my chart for all the previous weeks. So I tried something using Total and some conditions on the dates but it didn't work.