I have a simple series of power output, my query is very simple:
select power from head_unit
My requirement is to get all the first point’s where power > 4. Below graph will explain the issue:
I need all the points where there is a red cross.
I cannot check power = 4 as it will give me points on the opposite side of the curve as well.
Is it possible to get this value using query/subquery/flux?