Is it possible to do a CAST / CASE in influxdb

i would like to do some very simply binning of my data. In this specific case, if a value if greater than 0, i just want to set it to 100 (it’s a percentage) to indicate that the resource is in use. In SQL i guess i would do something similar to that specified at sql server - How do I perform an IF...THEN in an SQL SELECT? - Stack Overflow. can i do this in influxql?

Not at the moment. You can check out this GitHub issue for details: Divide result of one query by result of another query / CASE WHEN type functionality · Issue #5383 · influxdata/influxdb · GitHub