Just like topic. Is influxdb support to do mathematics across several measurements ?
Ex： SELECT ‘a1’ from ‘apple’ + SELECT ‘b1’ from ‘Grape’ + SELECT ‘c1’ from ‘Melon’
It’s not actually capable within influxdb itself, see here. That being said, I think it’s possible using something like grafana to put this together, but it’s not a clean way of doing it.
I’m not near a grafana instance with data at the moment, but will check in the morning and get back to you.
Last resort, pull the data down into a pandas dataframe (or set of frames) with influxdb-python and run the magic there. In terms of visualization, you can write that data back into influxdb itself or just render using bokeh or any other awesome python lib.