Here it is, Little Tricky , but done, I used the data in view Supplied by you on The Greens in View. My Initial Thought was LOD, But it Could not go far and Broke.
So in above you have 1, 2 and 1 green Weekwise
So Follow These Calcs:
So Created This View:
Created another Calc:
Created a Filter to get the Last Value which is actually Needed per Week:
Drag it to Filter and set TRUE and Format to Percent.
SET Calculation3 at The Level of Agency: Important
I Dragged Date to Detail too, but it Hardly makes any Difference, I think. Check attached
Looks Easy Now
Hope it Helps and Please Please Don't Forget to mark Helpful and CORRECT to Close Thread.
Sample Scorecard.twbx 37.5 KB
Wow! Thank You!
This was really useful. Really got my question answered on point !
One thing I would like to add for anyone who is going to implement this solution is that:
Please make sure you study every pill's calculation- for example FILTER is made to calculate downwards.
Thank You so much.
Thanks Abdul. Glad it Helped You