Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to get the cumulative percentage of the Module Assigned / Module Assigned (Completed) on a weekly basis. Something like I need to get the percentage of each row.
WeekEnd | Module Assigned | Completed | % Completion |
---|---|---|---|
6/19/2015 | 3 | 1 | 33.33% |
6/26/2015 | 274 (271+3) | 114 | 41.61% |
9/25/2015 | 280 (274+6) | 119 | 42.50% |
10/30/2015 | 282 | 120 | 42.55% |
11/6/2015 | 290 | 123 | 42.41% |
11/13/2015 | 344 | 127 | 36.91% |
Here's my expression for the Module Assigned and Completed (both in Full Accumulation already)
Module Assigned = count(Training)
Completed = count({$<Status = {'Completed'}>} Training)
I think the problem is here that Module Assigned and Completed columns are expressions with full accumulation. They are not dimensions.
Thanks Andrew. I got it now.
This method will work if you have the count function from your script and then group by WeekEnd dimension and store it into QVD. Or from the QVW directly, use the AGGR function since the data was loaded per day. So we need to aggregate all the data into WeekEnd dimension.