Is influxdb support to do mathematics across several measurements?

,
1

Hi,
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’

2

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.

3

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.

4

It is also possible to create a new measurement containing the result using Kapacitor. Here is a streaming example and a batch example.