Error timezone.location

InfluxDB 2
,
1

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
2

Hi, I’m having the same problem. Due to the aggregation function used, I originally used this:

import “timezone”
option location = timezone.fixed(offset: 1h)

But daylight saving time started recently, so things got messed up. Same as you, I wanted modify query like this (that should be DST-aware)

import “timezone”
option location = timezone.location(name: “Europe/Berlin”)

I got the same error, too. My InfluxDBis running as a Windows service and it seems Flux runtime can’t find any IANA time zone database on Windows.

Can anyone suggest a way to solve this?