I have been doing a lot of research regarding a way to make the query on a measure dependent on the value of another measure on influxDB, however, I cannot find a viable solution, I still have the problem of "No Data" while on the graphs we see that the query should return values.
Here is the approach I tried with no viable results:
from(bucket: "nom_du_bucket")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == "nom_du_measurement_1" or r["_measurement"] == "nom_du_measurement_2")
|> filter(fn: (r) => r["_field"] == "paramètre_1" or r["_field"] == "paramètre_2")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> filter(fn: (r) => r.paramètre_2 > 1000)
