What Grafana version and what operating system are you using?
Grafana version: v8.2.3
Operating system: Ubuntu 20.04
What are you trying to achieve?
Panel with possibility to aggregate timeseries from BigQuery by day and week based on custom interval variable.
How are you trying to achieve it?
Created new variable $interval with 1d and 1w values.
Used __timeGroup(time_column, $interval) macro.
Set dashboard time zone to “Europe/Berlin”.
Chart shows correctly except:
- when 1d is selected: days are from midnight UTC to next day midnight UTC.
- when 1w is selected: weeks are from Thursday midnight UTC to next week Thursday midnight UTC.
What did you expect to happen?
- days starting at midnight according to dashboard timezone
- weeks starting on Monday midnight according to dashboard timezone
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.