So, here's my next thought (for gauge #1 - 13 weeks)...I'm versed in sql, so my thoughts go to dateadd. I could be totally off here as to a formula in Qlik....:
Count(If( [Rct_Date]-[ERF_END_Date]<=0,1)) / Count( Total Rct_Date])*100
I know the expression is not quite right, as I have an error, but can anyone direct me?
Again, what I am trying to accomplish is?
- create a measure for 3 gauge chart showing me % on time deliveries.
- A gauge chart for each time period of 1,4,13 weeks).
Here is my needed calc:
count of items classified as On Time/count of total population during reporting period)*100
In general, use aggregation functions in expressions:
Count(If( [Rct_Date]-[ERF_END_Date]<=0 and [Rct_Date]>=Today()-13*7 ,1)) / Count( Total If([Rct_Date]>=Today()-13*7,Rct_Date]))*100