Hello I have a query like this to display data from my sensors on dashboard:
import "timezone"
option location = timezone.location(name: "Europe/Bratislava")
from(bucket: "db")
|> range(start: 2022-06-11T01:48:00Z, stop: 2022-06-11T03:48:00Z)
|> filter(fn: (r) => r["_measurement"] == "sens")
|> filter(fn: (r) => r["device"] == "first_device")
|> filter(fn: (r) => r["location"] == "sk")
|> filter(fn: (r) => r["_field"] == "first_device_temperature_1" or r["_field"] == "first_device_temperature_2" or r["_field"] == "first_device_temperature_3" )
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> yield(name: "mean")
On dashboard I can see the data (my time is 1:50 and graph display 3:50) +2hour offset (I know that database systems use UTC timezone) but I specify timezone in query and I have still same results.