in my setup i’m relying on window, integral, hourSelection and date.
I’ve noticed that my data is saved in UTC but i live in a place which has a different timezone.
Now if i start to window by day or performing integrals or hourSelection i’ve noticed that it starts to get tricky if i want to “relate” them properly to my timezone (e.g. hourSelection needs to be compensated manually and window by day might start earlier).
The question here is how can i compensate properly and in an elegant way?
I know there is
option location = timezone.location(name: "location")
but how can i use it in all the data retrieved from my query e.g. in map function