Manipulation of data from multiple variables possible?

  • What Grafana version and what operating system are you using?
    v. 9.0.8

  • What are you trying to achieve?
    Calculate vapor pressure deficit using Temp and Humidity readings fed to grafana via InfluxDB

  • How are you trying to achieve it?
    Server-side expressions - very beginner

Hi everyone, I’m VERY new to Influx/grafana. I have a small bank of sensors monitoring a grow tent. These sensors are feeding data to Influx and so on.

I am attempting to use temp/humidity readings to calculate other metrics similar to those in this post. Formulae for these measures are found here.

I’d like to know whether I can perform this kind of data manipulation server-side using InfluxDB? If not, is it possible with another database?

Thanks so much and apologies if this is an entirely ignorant question!

Welcome @chaulkey to the Grafana forum.

A formula like this…

will only be possible using Flux functions (such as this). You would have to do a map() function to do the conversion. If you do not know how to do this, check out InfluxDB university to learn Flux.

If you are using InfluxQL, then as far as I’m aware there is not currently any support in InfluxDB for exponents, which means that your equation can’t be calculated.