I hava a task that has to create a daily total but I need to aggregate the totals in the local timezone.
The task itself does not need to run in the local time zone, but the query needs to aggregate in the correct zone.
Reason: Grafana adjust the timestamp to the local time. This means that when I aggregate at 23h59 UTC (to keep the date in relation to the total), it will be displayed as 00h59 in my timezone and show the next day as the date.
I was also thinking in the edgecase DST how will this be displayed since this will add another our to the local time. When viewing a whole year there will be half a year using 22h59UTC and the other half 21h59UTC.
If someone has a better suggestion on how to do this, please share.
Somehow the location option does not accept any IANA timezone.
option location = timezone.location(name: "Europe/Brussels")
error calling function "location" @8:19-8:61: unknown time zone Europe/Brussels
