Hello
I’m trying to create a chart for a month to match my energy consumption for a billing window.
My billing window starts on 25 of the month for 30 days.
Is this possible using the aggregateWindow() function?
If not, please advise of how I can achieve this.
Hello @t481,
So flux does support calendar months:
Downsample by calendar months and years
every, period, and offset parameters support all valid duration units, including calendar months (1mo) and years (1y).
You might be able to use that with
to achieve what you want.
something like
from(bucket: "energy_data")
|> range(start: -2mo) // Ensure we capture enough data for alignment
|> timeShift(duration: -25d) // Shifts the time backward to start the window on the 25th
|> aggregateWindow(every: 1mo, fn: sum, createEmpty: false)
|> timeShift(duration: 25d) // Shift back to restore original timestamps
|> yield(name: "monthly_energy")
I haven’t tested it though so lmk. Might be problematic for certain months? I’m not sure rn. I need to think it through.
