Hi and happy new Year,
i have problems showing some summarized Data in the correct Month in Grafana or InfluxDBUI
My summarize is always the last Timestamp of the month in this case 01.01.2023 0.00 AM
The Problem is that summarize is for December and it will be shown as the last Timestamp from the sum.
Timeshift doesn´t help me because it shifts all Data back or forward 1 month.
Here a Picture what i mean, both Bars are in January but the first (8,66kwh) have to be in December.
Here my code:
from(bucket: "solarkraftwerk") |> range(start: -1mo, stop: now()) |> filter(fn: (r) => r["_measurement"] == "solarkraftwerk") |> filter(fn: (r) => r["_field"] == "todaykwh") |> aggregateWindow(every: 24h, fn: last, createEmpty: false) |> truncateTimeColumn(unit: 1m) |> aggregateWindow(every: 1mo, fn: sum, createEmpty: false)