Problem with Placing the Bars to the right Date (Month)

Grafana InfluxDB
1

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.

1
11931×1027 155 KB

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)