Bar chart showing wrong values

[gerhard5]

My influxDB has a time series of hourly prices. I want to have a bar chart with the latest price of each day for the last 7 days.
This is my simple query: SELECT first(“value”) FROM “0_userdata.0.Hauptzähler.Tagesstrompreis” WHERE $timeFilter GROUP BY time(1d) fill(null)
In table view I see the latest price of the day is always at 00:00 of the next day.
I see in table view always time 2024-06-xx 02:00:00 but different prices to the right but not the first (or even last) of each day.

How do I have to change this query to get the correct result?

Regards Gerhard

• What Grafana version and what operating system are you using?

• What are you trying to achieve?

• How are you trying to achieve it?

• What happened?

• What did you expect to happen?

• Can you copy/paste the configuration(s) that you are having problems with?

• Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

• Did you follow any online instructions? If so, what is the URL?

[ebabeshko]

It’s not ‘bar chart showing wrong values’, but rather ‘query returns wrong values’. Could be a timezone issue.

See also:

Issues with select last() when using group by time(1d)

When using SELECT last() to get the last value of my average value it works fine when using GROUP BY time(1) but when using GROUP BY time(1d) it uses a value from the next day. Needed value is 3.40 but when using time(1d) the value is 4.67 Anyone here know why this is happening and how to fix it? [last(1d)]