NOW GENERALLY AVAILABLE InfluxDB 3 Core and Enterprise. Start fast, scale faster.
@Ulrich In this post, I helped the person calculate the time spent in a given state. Did you see it / try it already?
I am sure what you are trying to do is possible in Flux. I will spend some time later if I can.