Forum Discussion
undefined
THe months of March through October are a daily reading (1X day)
THe winter months Nov-Feb are a rolling average over three years soIf I pulled July 1 2023 the rolling average would be average all data from:
2023 Jan & Feb, 2022 Nov, Dec, Jan, Feb, 2021 Nov, Dec, Jan, Feb
When I run the script I have above it comes out correct but it reports it out as a daily average instead of the average for the year.
The July 1 2023 data point is then subtracted by the Winter Running average:
July 1, 2023 = 200 cf
Winter Demand for the years in question = 100 cf
Result should be 200-100 = 100 cf.
Instead the winter demand only recognizes the winter values and will not report against the summer.
So as a result the summer value July 1, 2023 has no subtraction.
The graph above is how the winter demand is printing out and as you can see there is no values for the summer. I need the winter demand to reflecct the entire year value.