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 can i do this in influxql?


Not at the moment. You can check out this GitHub issue for details: