Issue with transformation: Prepare time-series -> Multi-frame time series

Grafana Dashboards
1

I am using Postgres data source to get data:

select report_date, name, value from T where report_date in (‘2023-07-18’,‘2023-07-25’)

Here report_date column has type DATE.

I am plotting the Bar chart using transformation: Prepare time-series → Multi-frame time series

The bar chart is displayed, but the x-axis labels are shifted by 1 day back - they are:

                       07/17   and 07/24

How to fix it?

2

Is your report_date column UTC?

3

I think you are right - this is Time Zone configuration issue.
Changing default_timezone in Grafana’s defaults.ini
from
browser
to
UTC
makes the difference.

Thank you a lot!

2 Likes