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")

Welcome @Cyrill.Sneer Can you create a working Flux query that simply returns all the measurement values (null or otherwise) along with their timestamp? If yes, post the query here along with a snippet of the returned data. That will help others help you.

Hello @grant1 , thank you very much for the welcome :slight_smile: I haven’t defined the time series yet. I’m just joining the measures. Here is my query: from(bucket: "openautogen") |> range(start: v.timeRangeStart, stop:v.timeRangeStop) |> filter(fn: (r) => r._measurement == "Growatt_PLoc…

What happens if you add this? |> group(columns: ["_time"])

[image] grant1: |> group(columns: ["_time"]) |> last() |> group(columns: ["_value", "_time"], mode: "except") It look great! Thank you for this solution. Any other question. Can i make a CSV Export with this result?

[image] Cyrill.Sneer: Can i make a CSV Export with this result? 'Fraid not…See post below. [image] CSV export in InfluxDV V2 InfluxDB 2 I started my journey into InfluxDB with the free cloud hosted version ( “InfluxDB Cloud Serverless”). What really helped me as a…

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	747	April 20, 2021
Fill data with last value before time range InfluxDB 3 query , sql	1	106	December 1, 2025
Get last measurement not working as expected Client SDKs java	10	178	August 19, 2025
Pick up row has null data by pivot Fluxlang query , flux	2	1146	February 9, 2022
GROUP BY tag but use last(time) InfluxDB 1 query	0	344	February 8, 2022

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

Related topics