I’m using InfluxDB2 with Flux but that is probably also valid for previous versions.
When trying to get daily aggregated values, a day seams to be defined as a day in UTC time. But I’m in UTC+1 so I’m always getting the sums from 01:00 day1 to 01:00 of day2. Is there a way to change this behavior?
from(bucket: "example-bucket") |> range(start: -1w) |> filter(fn: (r) => r._measurement == "example-mesurement" and r._field == "some-continuous-growing-value" ) |> aggregateWindow(every: 1d, fn:max)
The aggregation won’t stop at 24:00 my time of a given day but will run till 1:00 of the following day (which is correct in UTC time)