I have 5 flags for 5 fields that rate timeliness of service.
IF(A - Today()>0,1,0) AS ATimeFlag,
IF(B - Today()>0,1,0) AS BTimeFlag
IF(C - Today()>0,1,0) AS CTimeFlag
IF(D - Today()>0,1,0) AS DTimeFlag
IF(E - Today()>0,1,0) AS ETimeFlag
When I create a table it looks like this:
Now what i need to do is Average all the percentages from the table above which should give me a result of 83%.
But didn't work.
PS. I still haven't fully wrapped my head around AGGR().
Any thoughts appreciated!
Unable to open/read
Services - Copy.xlsx file
In feature no need to send full data. based on u r issue/requirement just send mock value with few rows should be enough. Thanks
Services - Copy.xlsx is the same as Demo Data.QVD.
You really need these three:
The dates used to create the flags are in the Ethnicity file.