Good morning, i need your help with a flux query. I want to display several measurements in a uniform temporal sequence (every 10 seconds). However, not everyone has it at that time a value. In this case, I would like to have the last value that is the shortest back displayed. Is that possible? E…

and just maybe these 3 statements will give you the correct results? |> group(columns: ["_time"]) |> last() |> group(columns: ["_value", "_time"], mode: "except")

Flux Query: Join by time and fill null-values with the last value

grant1 February 12, 2025, 2:22pm 7

'Fraid not…See post below.

Topic		Replies	Views
Get the last value from a different measurement on a specific point of time InfluxDB 2 influxdb , query , flux	4	685	April 20, 2021
Pick up row has null data by pivot Fluxlang query , flux	2	1126	February 9, 2022
GROUP BY tag but use last(time) InfluxDB 1 query	0	334	February 8, 2022
Influxdb query last row of all series in a measurement Kapacitor influxdb , influxql	5	26326	November 13, 2019
Extending "last" value to now InfluxDB 2 flux	2	1942	August 1, 2022

Flux Query: Join by time and fill null-values with the last value

Related topics