Closed simonhac closed 1 year ago
the base rolling sum is right but I didn't update the period grouping to take into account how the rolling sum works, so it was just summing the rolling sum dataset for season (3 months), quarter (3 months) and half year (6 months).
I should summed up the period first, then run it through the rolling sum calculation.
This looks reasonable — Year to August 2022 totals 207,554 GWh:
However, this looks dodgy:
Year to Winter 2022 totals 620,928 GWh:
(This should sum the 4 seasons up to and including the selected season, but seems to be summing a period 3 times as long.)
Year to 2022Q2 totals 618,004 GWh:
(This should sum the 4 quarters up to and including the selected quarter, but seems to be summing a period 3 times as long.)
Year to 2022H1 totals 1,233,554 GWh:
(This should sum the 2 half-years up to and including the selected half-year, but seems to be summing a period 6 times as long)