I am having an issue with flux when it comes to getting the right values based on time. I have 2 queries as you see below. One that queries the data for 1 day and the other that query the data for 1 week. On the value for grid for 1 day (6/03), I get 9,1760.19 kWh On the value for grid for 1 week,…

Try to play with timeSrc in the aggregateWindow and see if it helps: [image] Month wrong beginning InfluxDB Try to change the following line: to this one: |> aggregateWindow(every: v.windowPeriod, fn: max, createEmpty: false, timeSrc: "_start")

That does not change anything. In the flux script, the only line that changes is line 4 where the unit moves from 1d to 1w The value for the day should be the same. Not sure why it is not.

So I checked the data and the difference between the 2 is that in the case of the daily query, the aggregatewindow starts at 01am where for the weekly one, it will shows on the table list a value data for 6/4 at 12:00:00 PDT. I believe the weekly one to be wrong because I have another aggregation b…

You can try putting an offset into the aggregateWindow function. Several examples that I created here . Example: |> aggregateWindow(every: 1w, offset: -3d, fn: sum) // sums the 7 days of each week to get the total used per week, and use -3d as the offset to move the weekly aggregate to start on a…

Time Shift issue with Grafana/Flux

Grafana

ebabeshko June 3, 2025, 7:48pm 2

Try to play with timeSrc in the aggregateWindow and see if it helps:

Topic		Replies	Views
Transitioning from InfluxDB 1.x InfluxQL to 2.x Flux query language Grafana	5	10302	December 30, 2023
Please help with flux query - date not correct on bar chart InfluxDB	3	690	January 27, 2023
Data is one day ahead Grafana influxdb	1	212	May 16, 2024
Wrong value on aggregation (daily consumption) InfluxDB flux	6	134	June 16, 2025
Bar chart data panel, last timing group (aggregation to day, week or month) shows twice with different data Bar Chart Panel	1	957	November 6, 2023

Time Shift issue with Grafana/Flux

Related topics