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.
|> 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!!