I am running Grafana 7.3.7 with Clickhouse DB. My data is stored in UTC time format. When I use the table panel and select a date column select datetime .... I always see the time in UTC in the table panel no matter what timezone the dashboard or users TZ is set to. The graph panel will display the time selected by select datetime... with the correct timezone if I return it as epoch milliseconds. This doesn’t work with the table and the only way I seem to get the correct timezone is to convert it in the query select toDateTime(datetime, 'EST').... however I can’t hardcode the query this way for every user.
This topic was automatically closed after 365 days. New replies are no longer allowed.