I have a list of personnel, on each given day they may have 0-15 records with a score of 0 or 100.
Is there a way to build a chart type report to give me a rolling average of an individual personnels scores for each day?
IE: January 1 - Average is just January 1 data
January 2 - average score of Jan 1 and Jan 2
Jan 3 - average score of Jan 1, 2, and 3.