Grafana Difference of Values from 00:00 to 23:59

  • What Grafana version and what operating system are you using?
    Grafana 9.1.3 installed in a Raspberry Pi with Home Assistant.

  • What are you trying to achieve?
    Create an Energy Metering Dashboard that shows me the daily consumption.

  • How are you trying to achieve it?
    I have the energy value in (kWh) updated every 10s (increasing). I created a bar chart that calculates the daily difference between the energy.

  • What happened?

It calculates the difference of 1 day of data but not from 00:00 to 23:59 but from 20:00 to 20:00, why? I don’t know. There’s no shifting I could do so the time reference move.

  • What did you expect to happen?

I need a bar graph that show me the daily energy used starting from 00:00 to 23:59 Like this one (not Grafana):

Note: I can graph the instant increases of the Energy variable as shown below:

I just need a bar graph that could subtract A-B from the right time to time.


Welcome @mcmchrisyt to the Grafana forum.

What timezone is your browser set to, i.e. what do you see in the lower most line in this screenshot?

If I had to guess, I would think you are storing and querying the GMT values, hence the difference by 4 hours.

I am using UTC-4:

Are the values in InfluxDB stored with UTC time?

They are stored with UTC-4 (Local), but if I switch the toggle to (UTC) the time on the image below changes to 21:00.

Is there any way you could store a few days of data in UTC (in Influx), keep your browser time setting to Santo_Domingo, then run the same query (daily consumption) and see if the graph is still off by 4 hours?