Hello. When in this query, I consult the energy consumed per day (kWh), why does it mark the time at 2:00? I think it should mark 0:00.
The error appears in grafana. In influxdb, each metric is correct at 00:00 of each day. But the rest of the grafana dashboards have the correct time (the error only occurs in this dashboard, so I think there is an error in the flux code).
The code is the following:
IMPORTADA = from(bucket: "energymeter")
|> range(start: -1w, stop: v.timeRangeStop)
|> filter(fn: (r) => r._measurement == "IMPORTADA")
|> aggregateWindow(
every: 1h,
fn: (tables=<-, column) =>
tables
|> integral(unit: 1h)
|> map(fn: (r) => ({ r with _value: r._value})), createEmpty: false, timeSrc: "_start")
|> map(fn: (r) => ({
_time: r._time,
_value: r._value,
_field: "IMPORTADA_DIARIO"
}))
|> aggregateWindow(every: 1d, fn: sum, createEmpty: false, timeSrc: "_start")
|> yield()