Hello friend,
Appreciate your support 
Well, I think you understood my problem differently.
In the example that I showed using Grafana bar chart, I have presented daily energy consumption of multiple zones in a building individually for 60 days. I have used separate InfluxDB queries for computing daily energy consumption (for 24hrs) by integrating respective hourly energy consumption time series individually.
My question now is “how to compute daily energy consumption of entire building as a single time-series for 60 days?” The simple math representation of the above state problem can be represented as follows:
Days | Zone A | Zone B | Zone C | Entire Building
1 | 10 | 8 | 3 | (10+8+3) 21
2 | 23 | 0 | 10 | (23+0+10) 33
3 | 15 | 5 | 10 | (15+5+10) 30
4 | 6 | 9 | 21 | (6+9+21) 36
…
…
…
60 | 21 | 8 | 5 | (21+8+5) 34
How do I implement this in Grafana using InfluxDB query?
I think Merge & Join doesn’t help in achieving the desired result as above.
Thanks in anticipation.
Best,
Bala
