Forum Discussion

Nankaina's avatar
Nankaina
Helper I
2 years ago
Solved

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, ...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago
Based on the locations of the shifts

Where are these shifts defined?

Nankaina's avatar
Nankaina
Helper I
2 years ago

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's avatar
    lbendlin
    Super User
    2 years ago

    Please provide sample data that fully covers your issue.
    Please show the expected outcome based on the sample data you provided.

    • Nankaina's avatar
      Nankaina
      Helper I
      2 years ago

      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's avatar
        lbendlin
        Super User
        2 years ago

        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?