Hi, I’m using InfluxDB2 with Flux but that is probably also valid for previous versions. When trying to get daily aggregated values, a day seams to be defined as a day in UTC time. But I’m in UTC+1 so I’m always getting the sums from 01:00 day1 to 01:00 of day2. Is there a way to change this behav…

Hello @chris_b , Welcome! Here is documentation on manipulating timestamps. I believe many funcitons outlined there will be useful to you. Manipulate timestamps with Flux | InfluxDB OSS 2.1 Documentation Use Flux to process and manipulate timestamps. If I’…

Hi @Anaisdg , thanks for your reply. Adjusting the range is not really an issue. My biggest concern is handling the aggregateWindow(every: 1d, fn:max). In my case I have a datasource that accumulates daily values (energy generation in this example) that resets every day on 0:00 to zero. Unfortunat…

Also looking for a solution here. I want to run the aggregate function over set day windows. I tried setting the start time exactly to the start of the 24hour window I want to use but the timestamps returned still use UTC midnight as the time value. Also don’t want to rely on time shifting if possi…

Hello, I wonder if you found solutions for this. I am using influxQL at V1.8 and posted a question similar to this. [image] InfluxDB OSS 1.8 invalid data for different sampling Hi All, I just actually notice that there is some discrepancy that I have seen in my influxD…

After hours of debugging, I’ve found that you have to add a “compensation” to the timezone on the aggregateWindow function using the offset parameter. Not straightforward, but seems to be working. You can try it out. For an offset of GMT-03:00 you should add the difference, so: aggregateWindow(eve…

It is manageable by the location argument aggregateWindow() function | Flux Documentation in aggregateWindow(). Here is an example with Paris timezone: from(bucket: "example-bucket") |> range(start: -1w) |> filter(fn: (r) => r._measurement == "example-mesurement" and r._field == "some-continuo…

Aggregating by day and respecting timezones

Welcome & Getting Started

Henjoe_Gutierrez June 20, 2022, 1:29pm 5

Hello,

I wonder if you found solutions for this.
I am using influxQL at V1.8 and posted a question similar to this.

Topic		Replies	Views
Unexpected timestamp when using aggregated window per day InfluxDB 2 grafana , flux	7	2193	October 8, 2022
aggregateWindow aligned to specified timezone InfluxDB 2 influxdb , time , flux	1	1444	March 3, 2021
Daily Agreggation in local Timezone Fluxlang time , date , flux , downsample	5	711	December 3, 2021
Different result using Flux aggregateWindow() with timezone (standalone/cloud) InfluxDB 2 influxdb , flux , influxdb-cloud-2-0 , aggregate	3	144	January 15, 2025
Prepare aggregateWindow() for Meter-Reading ... or for correct time display in the output InfluxDB 2	0	298	February 10, 2023

Aggregating by day and respecting timezones

Related topics