Cannot set days and weeks interval according to dashboard timezone

  • 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”.

  • What happened?
    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.
    No errors.