Bar chart showing wrong values

[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)]