I am still running Influx 1.8, I was wondering if one could do a query across measurements in different databases e.g.
Each of those have a measurement:
Sensor1 - Total
Sensor2 - Total
Sensor3 - Total
I want to query all of these databases read the measurement “Total” and add them all up to get a total of the values across these measurements in different DB’s.
Looking at the documentation I see I can run multiple select statements by using the “;” between the select statements but that gives me individual values so it would just output
What I am trying to get to is “something” like Sensor1 Total + Sensor2 Total + Sensor3 Total = <Sum_Value>
Would someone mind pointing me in the right direction?