I have 2 types of measurements in a bucket:
- A: contains events with values “Start” and ‘Stop” (it could also be “On/Off”) that define time span of activity
- B: contains data from a sensor, produced continuously (at a higher pace than A)
I would like to extract the data from B which are within the time interval defined by “Start/Stop” in A (and calculate the mean of each time span)
This could be similar to using the aggregateWindow function with _time values of “Star/Stop” events instead of “period”.
Someone already raised the question but for InfluxQL (here)
I have tried many ways to solve this problem …