You could do this by using a scaffold data source with all the relevant dates in.
I'll try to put something together to show this, but don't worry - a solution is definitely possible.
I'd be interested in seeing that, thank you.
Finally got time to have a look at this. The solution is going to be easier than I thought, but I have a couple more questions:
- Did you want a 14-day average, as your excel formula is only 13 days. I'm assuming you want that day & the previous 13?
- Clarification is needed on what you want as an average. Is it:
- The overall average score for the past 14 days (e.g. Day 1, result is 90/100 = 90%, Day 14, result is 1/2 = 50%, average is 91/102 ~ 90%) - Weighted Average
- The average of the daily average score (e.g. Day 1, result is 90/100 = 90%, Day 14, result is 1/2 = 50%, average is average of 90% and 50% = 70%) - Average daily score
Both are fine, but I'll put the right one together if you let me know.