Bar graph legend is one hour ahead

Fluxlang
1

Hi,

My Grafana graphs are coming out one hour “ahead”, so my bar graph shows the amount of power for 14:00-14:59 under the axis legend 15:00, is there a way to fix this?

Thanks!

import "timezone"
option location = timezone.location(name: "Australia/Sydney")
from(bucket: "data")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "shelly_growatt_w")
  |> aggregateWindow(every: 1h, fn: mean, createEmpty: false)
  |> yield(name: "mean")
2

I don’t understand what you want to do.
Can you explain what you expected? Maybe with screenshot to explain the problem…

1 Like
3

Thanks, see the value -2466 above 19:00 that actually happened in the 18:00-19:00 period, so I basically want to show that the -2466 bar covers that period.

Screenshot_20240228-224711
Screenshot_20240228-2247111080×756 53.3 KB

4

Honestly, I don’t know if that’s possible.
When you use a panel like this, each piece of data is displayed at the value at which it was retrieved: if you average the values between one time and another, I think it’s the time of the last calculated value that appears…
Perhaps in the X axis parameters, with an offset?

1 Like