Running Average of Scores
Hi,
I've created a graph that has the date on the x-axis and scores on the y-axis. I would like to graph the average of those scores over time, such that the last point should be the current overall average. I've tried all the options, including "moving calculations" and while that one gets the closest to the current average with the last point, it is off by a few points.
Any suggestions for building the graph that I want so that each bullet point includes the average of the scores to that point?
Thanks.