Hello, I have a measurement value(x) that varies between 0 and 500. I would like to use a query to return 1 (Boolean) if this value is below a set value(y) for example 200 and 0 if it is above. I Need to do this for a discrete visualisation I want to use.
In SQL server I would use a case statement like
case when col_x < 200 then 1 else 0 end from <tablename> where <some condition>.
but in Influx since no case statement I have to use a calculation. I have seen another question similar to this where it suggests using floor() but I’m not sure how to do this. Any assistance appreciated