Forum Discussion
Recalculating Average after a Point
Hi all, I want to show a line graph with an average line that shifts about halfway through at a known point. Looking through the forums, I've seen ways to make moving averages, averages by year, ...
lbendlin
Super User
Super UserBased on the locations of the shiftsWhere are these shifts defined?
Apologies! These are manually chosen based on known changes in the data. They aren't recorded in the data currently (though I could easily add a column that denotes which months should start a new average, if that would help).
- lbendlin
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.I did.
The table listed shows all values needed. The line graph shows that same data with three averages: from Jul-22 to Feb-23, from Mar-23 to Oct-23, and from Nov-23 to Mar-24. Where one average stops and the next starts isn't calculated, it's known from external sources. In this case, I know there is a change after Feb-23 and a change after Nov-23.