# Summing up average of two fields

**URL:** <https://discuss.elastic.co/t/summing-up-average-of-two-fields/97659>\
**Category:** Kibana\
**Created:** [August 19, 2017, 1:48pm UTC](https://discuss.elastic.co/t/summing-up-average-of-two-fields/97659 "2017-08-19T13:48:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![iam.xtreme](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/iam.xtreme/32/20143_2.png) [@iam.xtreme](https://discuss.elastic.co/u/iam.xtreme)\
**Post date:** [August 19, 2017, 1:48pm UTC](https://discuss.elastic.co/t/summing-up-average-of-two-fields/97659/1 "2017-08-19T13:48:06Z")

</div>

Hi Team,

Just wanted to know , if it is possible to sum up, the average of two data fields to one?  
For example, say i have, two numeric fields dumped into elasticsearch, viz. 'expenses' and 'balance' and i have to calculate sum of average of expenses and average of balance.  
How can we achieve this?

Values for 'expenses' and 'balance' fields is set in few of the records, and not all of them which are present in elasticsearch

---

<div class="post-metadata">

**Author:** ![cjcenizal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cjcenizal/32/11216_2.png) [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)\
**Post date:** [August 21, 2017, 7:01pm UTC](https://discuss.elastic.co/t/summing-up-average-of-two-fields/97659/2 "2017-08-21T19:01:46Z")

</div>

Hi Tushar, I think this is something you can do with the Visual Builder visualization.

![image](https://us1.discourse-cdn.com/elastic/original/3X/d/d/dd38454d8444e0056f5a349a2bf5ec5e7d3ef74f.png)

Does this help?

CJ

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 18, 2017, 7:01pm UTC](https://discuss.elastic.co/t/summing-up-average-of-two-fields/97659/3 "2017-09-18T19:01:59Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
