Forum Discussion
Recalculating Average after a Point
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.
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?