Summing 2 series results to a single value

Grafana Elasticsearch
1

Hi

I created a panel and 2 queries.
Each query returns a single value.
My goal is to display a single value, which is the sum of both values.

Please advise.

Thanks
Shay

2

Hi @shaynaveh,

What version of Grafana are you using? You should check out transformations.

UPDATE:
I would now use the add new field from calculation transformation to solve this. Probably many different ways to get here…

Here is a dashboard example on our public sandbox:

https://play.grafana.org/d/7t-PJFlnk/reduce-2-series-to-single-value?orgId=1

old answer:

Here is an example I made with some dummy data representing two queries, where each query returns a single value. I then used two transformations to merge the values and sum them:

3

Hey,

Sum of two queries seems to be buggy with dynamic Dashboard

regards,

Tiki_

5

UPDATE:
I would now use the `add new field from calculation to solve this rather than the chained reduce transformations in the video. Probably many different ways to get here…
Here is a dashboard example on our public sandbox:

https://play.grafana.org/d/7t-PJFlnk/reduce-2-series-to-single-value?orgId=1