# Simple arithmetic in a Kibana visualization

**URL:** <https://discuss.elastic.co/t/simple-arithmetic-in-a-kibana-visualization/86000>\
**Category:** Kibana\
**Created:** [May 16, 2017, 7:01pm UTC](https://discuss.elastic.co/t/simple-arithmetic-in-a-kibana-visualization/86000 "2017-05-16T19:01:31Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![red888](https://avatars.discourse-cdn.com/v4/letter/r/ecae2f/32.png) [@red888](https://discuss.elastic.co/u/red888)\
**Post date:** [May 16, 2017, 7:01pm UTC](https://discuss.elastic.co/t/simple-arithmetic-in-a-kibana-visualization/86000/1 "2017-05-16T19:01:31Z")

</div>

I'm using Kibana's "Metric" visualization to get a count of all my docs (literally the simplest thing).

But I want to multiple that value by 100 so the value the visualization displays is the count \* 100.

I tried to use the json field but this does nothing (makes no change to the number the visualization shows):  
 ![](https://us1.discourse-cdn.com/elastic/original/3X/d/8/d8db1ef70538d5e2dc8d7c4c7f49e88868a3eb92.PNG)

===================  
Edit: I have a better understanding of my problem. I created a new pie chart visualization and added this json input and it successfully alerted the values for a specific field:

```
{ "script" : "doc['myfield'].value * 1.2" }

```

But what I'm doing is different because I'm not altering the value of fields but the actual count of the docs. Is there like a environment variable I can use in the json input box that represents the count of docs or like the count of all events for the metric?

---

<div class="post-metadata">

**Author:** ![Stacey\_Gammon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stacey_gammon/32/14025_2.png) [@Stacey\_Gammon](https://discuss.elastic.co/u/Stacey_Gammon)\
**Post date:** [May 16, 2017, 7:54pm UTC](https://discuss.elastic.co/t/simple-arithmetic-in-a-kibana-visualization/86000/2 "2017-05-16T19:54:28Z")

</div>

What version of kibana are you using?

You can do this with the a Time Series Visual Builder Visualization on the Metric tab in v 5.4.

 ![](https://us1.discourse-cdn.com/elastic/original/3X/1/5/1573a5c6c7e5861a026f4aa5c01dce8d6e9da78d.png)

---

<div class="post-metadata">

**Author:** ![red888](https://avatars.discourse-cdn.com/v4/letter/r/ecae2f/32.png) [@red888](https://discuss.elastic.co/u/red888)\
**Post date:** [May 16, 2017, 8:44pm UTC](https://discuss.elastic.co/t/simple-arithmetic-in-a-kibana-visualization/86000/3 "2017-05-16T20:44:35Z")

</div>

im on 5.3.0 is this impossible to accomplish with my version?

---

<div class="post-metadata">

**Author:** ![Stacey\_Gammon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stacey_gammon/32/14025_2.png) [@Stacey\_Gammon](https://discuss.elastic.co/u/Stacey_Gammon)\
**Post date:** [May 16, 2017, 9:41pm UTC](https://discuss.elastic.co/t/simple-arithmetic-in-a-kibana-visualization/86000/4 "2017-05-16T21:41:23Z")

</div>

Unfortunately no, I recommend upgrading.

---

<div class="post-metadata">

**Author:** ![red888](https://avatars.discourse-cdn.com/v4/letter/r/ecae2f/32.png) [@red888](https://discuss.elastic.co/u/red888)\
**Post date:** [May 16, 2017, 9:57pm UTC](https://discuss.elastic.co/t/simple-arithmetic-in-a-kibana-visualization/86000/5 "2017-05-16T21:57:15Z")

</div>

This is obviously outside the scope of my original question but can I upgrade in place? Like yum update from the ES repo? I currently have it pinned at 5.3. for the kibana package. Are upgrades like this supported/not a bad idea?

---

<div class="post-metadata">

**Author:** ![Stacey\_Gammon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stacey_gammon/32/14025_2.png) [@Stacey\_Gammon](https://discuss.elastic.co/u/Stacey_Gammon)\
**Post date:** [May 17, 2017, 11:17am UTC](https://discuss.elastic.co/t/simple-arithmetic-in-a-kibana-visualization/86000/6 "2017-05-17T11:17:54Z")

</div>

The safest bet is to follow the steps here: [https://www.elastic.co/guide/en/elasticsearch/reference/current/setup-upgrade.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/setup-upgrade.html) and [https://www.elastic.co/guide/en/kibana/current/upgrade.html](https://www.elastic.co/guide/en/kibana/current/upgrade.html)

Since you would be upgrading from 5.3 to 5.4 you can do a rolling upgrade for elasticsearch: [https://www.elastic.co/guide/en/elasticsearch/reference/current/rolling-upgrades.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/rolling-upgrades.html)

and a standard upgrade for Kibana:  
[https://www.elastic.co/guide/en/kibana/current/upgrade-standard.html](https://www.elastic.co/guide/en/kibana/current/upgrade-standard.html)

---

<div class="post-metadata">

**Author:** ![red888](https://avatars.discourse-cdn.com/v4/letter/r/ecae2f/32.png) [@red888](https://discuss.elastic.co/u/red888)\
**Post date:** [May 17, 2017, 5:45pm UTC](https://discuss.elastic.co/t/simple-arithmetic-in-a-kibana-visualization/86000/7 "2017-05-17T17:45:29Z")

</div>

I cant run kibana 5.4 with ES 5.3?

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [May 17, 2017, 6:21pm UTC](https://discuss.elastic.co/t/simple-arithmetic-in-a-kibana-visualization/86000/8 "2017-05-17T18:21:12Z")

</div>

@red888 you'll want to keep the version of Kibana matching the version of Elasticsearch to ensure there aren't compatibility issues.

---

<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:** [June 14, 2017, 6:21pm UTC](https://discuss.elastic.co/t/simple-arithmetic-in-a-kibana-visualization/86000/9 "2017-06-14T18:21:14Z")

</div>

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