Hi, I wrote this query: from(bucket: "statisticaldata") |> range(start: -24h) // we know that data is flushed daily |> last() |> filter(fn: (r) => r["_measurement"] == "systemStatus") |> filter(fn: (r) => r["_field"] == "conveyorSpeed") The result I get is: 2021-06-07 01:37:26 0 If…

Rows not sorted by time when using last()

richardthompson June 16, 2021, 6:00pm 10

Useful discussion, thanks, I appreciate that!

Topic		Replies	Views
Flux doesn't seem to sort on _time as is expected InfluxDB 2	3	2045	July 28, 2023
Flux not sorting data based on time, even using sort() function InfluxDB 2 time	0	65	November 16, 2024
Last() function returns a different value each time I submit the script InfluxDB 2 flux	1	225	January 10, 2025
JAVA client Library sort() does not return the data sorted InfluxDB 2 influxdb , query , flux	1	701	June 22, 2020
Sort by highest value InfluxDB 2 query	3	1469	August 19, 2022