I am desperately trying to get this query run correctly. 1st of all, the values are not correctly assigned to the dates. ->The 200Wh on the right is the value of the 22. of November → The 300Wh on the right is the value of the 21st of November → The 100Wh on the right is the value of the 20. o…

I had a similar issue as yours and solved it with the “offset” parameter in the aggregateWindow function. aggregateWindow() function | Flux 0.x Documentation aggregateWindow() downsamples data by grouping data into fixed windows of time and applying an aggregate or selector function to…

Latest (max) value of each day

InfluxDB 2

grant1 November 23, 2022, 11:58pm 9

@TimTom @codac

It seems that import timezone works in InfluxDB Cloud, but not OSS. See here and here.

Which version are each of you using?

Topic		Replies	Views
Flux query displays previous days data InfluxDB 2	0	595	April 4, 2023
Difference() got a time shift and there are duplicate dates at the end Fluxlang query	4	449	February 19, 2024
How to calculate with Influxdb Interface? Fluxlang query , flux	1	533	February 9, 2022
Result interpretation - Strange aggregate InfluxDB 2 time , query , flux	4	1072	December 21, 2021
Aggregating by day and respecting timezones Welcome & Getting Started	6	4685	August 6, 2024

Latest (max) value of each day

Related topics