# Manually Calculate Terms within a bar chart

**URL:** <https://discuss.elastic.co/t/manually-calculate-terms-within-a-bar-chart/35745>\
**Category:** Kibana\
**Created:** [November 27, 2015, 10:59am UTC](https://discuss.elastic.co/t/manually-calculate-terms-within-a-bar-chart/35745 "2015-11-27T10:59:06Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![lineman](https://avatars.discourse-cdn.com/v4/letter/l/b782af/32.png) [@lineman](https://discuss.elastic.co/u/lineman)\
**Post date:** [November 27, 2015, 10:59am UTC](https://discuss.elastic.co/t/manually-calculate-terms-within-a-bar-chart/35745/1 "2015-11-27T10:59:06Z")

</div>

Hello all together, i just started to get into Kibana 4, and i've the 1st little problem. Hopefully.

 ![](https://us1.discourse-cdn.com/elastic/original/2X/7/73de77f1880f6d0ab449ac9f5b60802fc9ee301a.png)

The bar shows different terms, called "events".

My problem is, that the correct status 1 = status 1 minus status 2

can anybody help me, of how to get this issue solved?

thanks and cheers Marco

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [November 29, 2015, 10:34am UTC](https://discuss.elastic.co/t/manually-calculate-terms-within-a-bar-chart/35745/2 "2015-11-29T10:34:49Z")

</div>

If you can't change the original data I suspect you'll be able to use a script field for this.

---

<div class="post-metadata">

**Author:** ![lineman](https://avatars.discourse-cdn.com/v4/letter/l/b782af/32.png) [@lineman](https://discuss.elastic.co/u/lineman)\
**Post date:** [November 30, 2015, 8:29am UTC](https://discuss.elastic.co/t/manually-calculate-terms-within-a-bar-chart/35745/3 "2015-11-30T08:29:54Z")

</div>

thank you very much Magnus. I'm going to read the manual about script fields and how to use them. any advice?  
thanks, Marco

---

<div class="post-metadata">

**Author:** ![Pieter\_Agenbag](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pieter_agenbag/32/4562_2.png) [@Pieter\_Agenbag](https://discuss.elastic.co/u/Pieter_Agenbag)\
**Post date:** [November 30, 2015, 12:54pm UTC](https://discuss.elastic.co/t/manually-calculate-terms-within-a-bar-chart/35745/4 "2015-11-30T12:54:53Z")

</div>

Yup - that should be simple enough with a scripted field.

Simply go to Settings  
choose your index and click on Scripted fields.  
Click "Add scripted field" and enter a name for the field  
Define your script , which should be "doc['status1'].value - doc['status2'].value"

Done - you should now have a status3 field to use.

 ![](https://us1.discourse-cdn.com/elastic/original/2X/7/75809a61513a144c569d34ba15f450a5762a1a1e.png)

---

<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:** [July 6, 2017, 2:07pm UTC](https://discuss.elastic.co/t/manually-calculate-terms-within-a-bar-chart/35745/5 "2017-07-06T14:07:56Z")

</div>