Hello I am using currently influx 1.7 in grafana.
I made query1:
Max force = SELECT “force” FROM “final” WHERE (“current” < 0.725) AND $timeFilter GROUP BY “coil_id”
query 2:
Max Drawing = SELECT max(“force”) FROM “final” WHERE (“speed” > 10 AND “force” > 10) AND $timeFilter GROUP BY “coil_id”
these two querys are working properly: on basis of above two querys I want to built my third query.
query3 :
query3:
average force= SELECT mean(“force”) FROM “FINAL” WHERE (“current” < 0.725 AND “force” > query2) AND $timeFilter GROUP BY time($__interval), “coil_id” fill(null)
average force = SELECT mean(“force”) FROM “final” WHERE (“force” > SELECT max(“force”) FROM “final” WHERE (“speed” > 10 AND “force” > 10) AND $timeFilter GROUP BY “coil_id” AND “currtent” < 0.725) AND $timeFilter GROUP BY time($__interval), “coil_id” fill(null)
is it possible to run this query in influxdb 1.7 or in influxdb 2.0 using flux ?
