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

Grafana InfluxDB
1

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

image
image1066×529 39.7 KB

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

image
image1054×456 20.9 KB

  • 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):

image
image1389×400 13.7 KB

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

image
image1647×422 38.8 KB

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

Thanks.

2

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?
image

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

3

I am using UTC-4:

image
image674×546 43.8 KB

4

Are the values in InfluxDB stored with UTC time?

5

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.

image
image1663×383 43.4 KB

6

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?