How to do mathematical operations to two queries of influxdb in grafana

Hi All,

Can anyone please show me how to do mathematical operations to two queries of influxdb in grafana.
Then i need to graph the resultant value.

Thanks in advance,
Lochana

If you are using the InfluxQL language (and not the new Flux language), then math between fields in a measurement is possible:

There is no support for cross-measurement or sub queries for InfluxQL. It is possible with Flux: https://davidgs.com/2019/using-cross-measurement-math-in-influxdb-flux/ and https://www.influxdata.com/blog/influxdb-how-to-do-joins-math-across-measurements/

Thanks @daniellee using Flux solved my issue.

1 Like