…as far as I know Europe/Berlin and Europe/Amsterdam defines the same time shift UTC + 1 so I would expect
I.
|> window( every: 1d, createEmpty: false , location: timezone.location(name: "Europe/Berlin"))
and
II.
|> window( every: 1d, createEmpty: false , location: timezone.location(name: "Europe/Amsterdam"))
behave the same.
Consider the following example:
import "array"
import "timezone"
testData = array.from(rows:[
{_time: 2023-01-14T23:00:00Z, _value: 10},
{_time: 2023-01-14T23:30:00Z, _value: 20},
{_time: 2023-01-15T00:00:00Z, _value: 30},
{_time: 2023-01-15T00:30:00Z, _value: 40},
{_time: 2023-01-15T01:00:00Z, _value: 50},
{_time: 2023-01-15T08:00:00Z, _value: 60},
{_time: 2023-01-15T08:30:00Z, _value: 70},
{_time: 2023-01-15T23:00:00Z, _value: 100},
{_time: 2023-01-15T23:30:00Z, _value: 200},
{_time: 2023-01-16T00:00:00Z, _value: 300},
{_time: 2023-01-16T00:30:00Z, _value: 400},
{_time: 2023-01-16T01:00:00Z, _value: 500},
{_time: 2023-01-16T08:00:00Z, _value: 600},
{_time: 2023-01-16T08:30:00Z, _value: 700},
{_time: 2023-01-16T23:00:00Z, _value: 1000},
{_time: 2023-01-16T23:30:00Z, _value: 2000},
{_time: 2023-01-17T00:00:00Z, _value: 3000},
{_time: 2023-01-17T00:30:00Z, _value: 4000},
{_time: 2023-01-17T01:00:00Z, _value: 5000},
{_time: 2023-01-17T08:00:00Z, _value: 6000},
{_time: 2023-01-17T08:30:00Z, _value: 7000}
])
testData
|> range(start: 2023-01-14T00:00:00Z, stop: 2023-01-18T00:00:00Z)
|> window( every: 1d, createEmpty: false , location: timezone.location(name: "Europe/Amsterdam"))
|> sum()
leads (correctly) to
whereas II. gives
which ignores the 1h time shift.
Any Explanation for this behavior?
Best,