# Summing 2 series results to a single value

**URL:** <https://community.grafana.com/t/summing-2-series-results-to-a-single-value/46696>\
**Category:** Elasticsearch\
**Tags:** elasticsearch\
**Created:** [April 27, 2021, 5:09pm UTC](https://community.grafana.com/t/summing-2-series-results-to-a-single-value/46696 "2021-04-27T17:09:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![shaynaveh](https://avatars.discourse-cdn.com/v4/letter/s/ebca7d/32.png) [@shaynaveh](https://community.grafana.com/u/shaynaveh)\
**Post date:** [April 27, 2021, 5:09pm UTC](https://community.grafana.com/t/summing-2-series-results-to-a-single-value/46696/1 "2021-04-27T17:09:56Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![anon70503803](https://avatars.discourse-cdn.com/v4/letter/a/8797f3/32.png) [@anon70503803](https://community.grafana.com/u/anon70503803)\
**Post date:** [May 1, 2021, 1:10am UTC](https://community.grafana.com/t/summing-2-series-results-to-a-single-value/46696/2 "2021-05-01T01:10:35Z")

</div>

Hi @shaynaveh,

What version of Grafana are you using? You should [check out transformations](https://grafana.com/docs/grafana/latest/panels/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](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:

> **[CleanShot 2021-04-30 at 15.08.00](https://cln.sh/CgvQYI)**
>
> GIF uploaded to CleanShot Cloud

---

<div class="post-metadata">

**Author:** ![tiki10](https://avatars.discourse-cdn.com/v4/letter/t/6de8d8/32.png) [@tiki10](https://community.grafana.com/u/tiki10)\
**Post date:** [March 28, 2022, 12:36pm UTC](https://community.grafana.com/t/summing-2-series-results-to-a-single-value/46696/3 "2022-03-28T12:36:00Z")

</div>

Hey,

Sum of two queries seems to be buggy with dynamic Dashboard

regards,

Tiki\_

---

<div class="post-metadata">

**Author:** ![anon70503803](https://avatars.discourse-cdn.com/v4/letter/a/8797f3/32.png) [@anon70503803](https://community.grafana.com/u/anon70503803)\
**Post date:** [May 5, 2022, 12:24am UTC](https://community.grafana.com/t/summing-2-series-results-to-a-single-value/46696/5 "2022-05-05T00:24:24Z")

</div>

**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](https://play.grafana.org/d/7t-PJFlnk/reduce-2-series-to-single-value?orgId=1)