Forum Discussion
Recalculating Average after a Point
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).
Super UserPlease 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.
- lbendlin
You could argue if that change was after February or after February plus March.
you could suggest the shifts after an absolute change over 40, or a positive change over 30 . or in many other ways. Are these shifts defined by you, the report designer, or are they defined by your report users dynamically?
The shifts are defined by the report designer, and do not dynamically change.