Issue on Grafana Time Series TimeZone

Grafana Bar Chart Panel
1

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

  • What are you trying to achieve?
    I would like to show time series with correct date.

  • How are you trying to achieve it?
    The query time series is on UTC. And the browser is in local time zone which is UTC + 8

  • What happened?

You can see in below image that the query result has been translated to UTC + 8. In the picture example it is 2024-02-23T16:00:00.000+08. Then the time range is also set to browser local time which is also UTC+8. But the data is plotted at 08.00 hour. Its treating the time series time interval as UTC.

image
image985×498 61 KB

  • What did you expect to happen?

The data should be shifted to the correc time according to the browser time.

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

2

The solution is to change the time to unix time stamp. In clickhouse, using toUnixTimestamp() function

1 Like