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 https://stackoverflow.com/questions/63447/how-do-i-perform-an-if-then-in-an-sql-select. can i do this in influxql?
Not at the moment. You can check out this GitHub issue for details: https://github.com/influxdata/influxdb/issues/5383