HELP - Adding multiple time-series in InfluxDB/Grafana


#1

Dear friends,

I am still an early-stage user of InfluxDB with Grafana.

I would like to find a simple approach to “add” multiple data streams at once.

A quick example of a Grafana dashboard (find the attached) presenting time-series data points from InfluxDB is used for illustration.

The bar chart presents time-series record of energy consumption per day of different points.

In the above, I would like to simply “add” all values everyday to compute aggregated energy consumption.

How do I implement this?

Your quick help will be appreciated.

Thanks & regards.

Bala


#2

Hi Bala,

Thanks for your question! Based on what you’ve written, maybe you could try merging or joining the multiple time series into a single stream? Please take a look at the documentation: here

Another option is to take a look at the aggregation functions listed: here

If I’ve misunderstood, please reply back and let me know.


#3

Hello friend,

Appreciate your support :slight_smile:

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