Forum Discussion
Helper IRecalculating Average after a Point
Super UserPlease provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Helper II 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?