Total consumption of kWh per day - error with 2 same days

[sandman1991]

Hello guys.
I would like to put together a dashboard that shows me the total energy consumption of the last 7 days.
This already works very well, but the current day (in the photo the 21.09.) is always displayed as two columns and not as a single day.
Unfortunately I don’t know what I did wrong.

I’m reading from Influxdb2.0.
my syntax:
from(bucket: “FBHome”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “stromverbrauch”)
|> filter(fn: (r) => r[“_field”] == “Wirkenergie”)
|> difference(nonNegative: false, columns: [“_value”])
|> aggregateWindow(every: 1d, fn: sum, createEmpty: false)

Thank you in advance for the help!!

[mattabrams]

welcome to the forum, @sandman1991

There are a TON of power-consumption-per-day topics on this forum. I would do a search over the past few years. There are lots of sample queries on good threads with input from advanced influx users. They are all a little different depending on the flavor of your setup and desired outcome, but I bet you’ll find some useful stuff if you go digging