Why is there this timeshift in grafana?

Grafana Bar Chart Panel
, , ,
1

grafik
grafik1598×818 69.7 KB

I am using Grafana 8.5.0. on Ubuntu 20.04 LTS.

In the picture above you can see a Bar chart.

I’ve selected 22-09-01 00:00:01 - 22-09-01 02:00:00 as Time range.
The corresponding table of the database is seen on the right site.

As you can see, the sum of the values that grafana queries ist correct, but the values are partially show on the wrong date.

Whats the reason for this?

What I want is to see the correct values for the correct days, so in this case 01.09.2022 should show 6.35

Thanks

2

What time zone are these dates in TS column?

3

The table (mysql) timezone is system. System is Europe/Berlin. Grafana is also running on the same system. The grafana Timezone is also Europe/Berlin (CEST)

1 Like
4

Hi @eporta ,

Have you found the reason of the issue OR is it still happening?

If this is still happening, then can you please try to reproduce this on the latest stable version of Grafana with your data as your data seems to be a bit unique and could help us to understand this phenomenon on the latest version.

Thanks