How to query record on specific intervals that were given by another query?

Hello everyone.

I’m struggling on how should write a flux query.

Let’s say :

  • I have a bucket named TestBucket where there are MeasurementA and MeasurementB.

  • MeasurementA where I want the intervals where its average value, every 5 sec, are lesser than 50.

  • I want to return the records of MeasurementB in the same intervals that was returned by the first point described.

So basically, I want to return the records of MeasurementB for the same time intervals, of 5 sec, in which the averages of MeasurementA’s records are lesser than 50.

How do I achieve that ? It is even possible in Flux Language ?

Thanks you all for your answers :slight_smile: