Hi Nagarjuna / Sinan,
Please see attached qvw file.
Data is under the Compass Training table.
Actually the data has no numerical data involved..Just the count of all the training I assigned per day and I want it actually to be grouped per week. Not sure how to do that in script.
Sorry if my question wasn't clear enough. But what I need to have is the percentage of each row.
This is the Actual Count each week.
This is the Full Accumulation
What I need to get is the percentage of each row. So for example, I should be getting 42.70% (120 / 281) for 9/25/2015, 42.75% (121 / 283).
Hope that makes sense.
I took your data and worked back to this table of non accumulated figures
WeekEnd Module Assigned Completed 6/19/2015 3 1 6/26/2015 271 113 9/25/2015 6 5 10/30/2015 2 1 11/06/2015 8 3 11/13/2015 54 4
You can make a straight table with the Weekend as dimension, all other columns are expressions. Instead of using the accumulation feature of the straight table use instead the expressions here to calculate the accumulation then the last column is the ratio of the preceding two expressed as a percentage.
WeekEnd Module Assigned Completed RangeSum(Above([Module Assigned],0,RowNo())) RangeSum(Above(Completed,0,RowNo())) RangeSum(Above(Completed,0,RowNo())) / RangeSum(Above([Module Assigned],0,RowNo())) 6/19/2015 3 1 3 1 33.33% 6/26/2015 271 113 274 114 41.61% 9/25/2015 6 5 280 119 42.50% 10/30/2015 2 1 282 120 42.55% 11/06/2015 8 3 290 123 42.41% 11/13/2015 54 4 344 127 36.92%
hope this helps!
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.