Thanks for the help in advance! import "sql" data=from(bucket: "TEMP_DATA") |> range(start: -2m) |> filter(fn: (r) => r["_measurement"] == "placeholder_1") |> group() |> last() |> keep(columns: ["_time"]) |> limit(n:1) batchinsert=from(bucket: "Bucket2") |> range(start: data["_time…

Brilliant suggestion @gazpachoking ! You are correct in that one must get an individual record. @mauflege : There are probably several ways to do this, but in my sample dataset I got it to work using the Extract Scalar Value feature. Something like this should work: import "sql" data=from(bucket: …

Referencing "_time" from previous query as "range(start: , stop:now())" for a following query. I can't get it to work

InfluxDB 2

grant1 May 4, 2023, 7:00pm 15

Perfect explanation. Thanks!

1 Like

Query timerange from a influxdb tag and use it as variable for a second query

Topic		Replies	Views
How to use query result in range() influxdb , query , flux	8	2796	May 17, 2022
Help for InfluxQL to Flux InfluxDB 2	7	606	April 23, 2023
InfluxQL query to Flux Fluxlang influxql , flux	1	508	April 17, 2023
Need help. Influxdb1 vs. influxdb2 with flux InfluxDB 2	3	255	October 5, 2023
_time column needed to get a result	4	311	February 1, 2023

Referencing "_time" from previous query as "range(start: , stop:now())" for a following query. I can't get it to work

Related topics