I am desperately trying to get this query run correctly.
1st of all, the values are not correctly assigned to the dates.
->The 200Wh on the right is the value of the 22. of November
→ The 300Wh on the right is the value of the 21st of November
→ The 100Wh on the right is the value of the 20. of November
→ The left 100Wh is the value of the 19th of November
→ The left 200Wh is the value of the 18th of November
→ The left 300Wh is the value of the 17th of November
→ The 16th of November doesn’t have a value.
So I dont want to have two Time comlums for the current day, which is I geuss the cause for the values to get shifted by one day.
2nd, As you can see the timestamps all go to 1:00 (instead of the now() timestamp on the current day) which is the wrong time. As the max value of each day is the last value of each day, I would like to set this time to 23:59 instead of 1:00.
3rd, I would like the timestamp on the x-axis to show “DD MMM” only.
From what I see in your original screenshot we are doing similar things.
I have a flux query based on the energy counter of my pv inverter. I’m calculating the produced energy by using the difference of the last counter value of each day.
Yes I’ve read that as well afterwards. I’M using InfluxDB OSS 2.0.9.
I’m running my instances as dockers.
So I’ve set the timezone of InflxuDB, Grafana and the data gathering Docker with parameters to Europe/Berlin.
Even witht he query of @TimTom I have the same issue, no matter if I use UTC or local time.