# Script - round an average

**URL:** <https://discuss.elastic.co/t/script-round-an-average/184320>\
**Category:** Elasticsearch\
**Created:** [June 5, 2019, 9:50am UTC](https://discuss.elastic.co/t/script-round-an-average/184320 "2019-06-05T09:50:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![simple\_commentateur](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/simple_commentateur/32/45428_2.png) [@simple\_commentateur](https://discuss.elastic.co/u/simple_commentateur)\
**Post date:** [June 5, 2019, 9:50am UTC](https://discuss.elastic.co/t/script-round-an-average/184320/1 "2019-06-05T09:50:18Z")

</div>

Hello,

In Kibana, i want to display the average of a field in Metric Vizualization

Average value : 24573.222

 ![metric](https://us1.discourse-cdn.com/elastic/original/3X/a/3/a35273dcd84c55b13b42a5bc4e084251a8a3d8f5.png)

But the display don't change, it still show 2453.222

I even try this but it still don't work :

```
{

 "script": {

   "inline": "def nb = 0; while(nb < doc['nbr_ligne'].value){nb++} return nb",

   "lang": "painless"

 }

}

```

Is there any way to have an average without decimal?

Thanks

---

<div class="post-metadata">

**Author:** ![simple\_commentateur](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/simple_commentateur/32/45428_2.png) [@simple\_commentateur](https://discuss.elastic.co/u/simple_commentateur)\
**Post date:** [June 5, 2019, 10:06am UTC](https://discuss.elastic.co/t/script-round-an-average/184320/2 "2019-06-05T10:06:11Z")

</div>

EDIT :

I try : Math.round(doc['nbr\_ligne'].value), and it don't work too.

---

<div class="post-metadata">

**Author:** ![simple\_commentateur](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/simple_commentateur/32/45428_2.png) [@simple\_commentateur](https://discuss.elastic.co/u/simple_commentateur)\
**Post date:** [June 6, 2019, 8:40am UTC](https://discuss.elastic.co/t/script-round-an-average/184320/3 "2019-06-06T08:40:37Z")

</div>

Any one have a solution?

---

<div class="post-metadata">

**Author:** ![rjernst](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rjernst/32/6363_2.png) [@rjernst](https://discuss.elastic.co/u/rjernst)\
**Post date:** [June 20, 2019, 11:36pm UTC](https://discuss.elastic.co/t/script-round-an-average/184320/4 "2019-06-20T23:36:38Z")

</div>

Your script operates on each individual document, not on all the values accross all docs matching your aggregation. To have a script run on all the values collected, you need to use a scripted metric aggregation. However, that is not yet available in kibana: [https://github.com/elastic/kibana/issues/2646](https://github.com/elastic/kibana/issues/2646)

---

<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 18, 2019, 11:36pm UTC](https://discuss.elastic.co/t/script-round-an-average/184320/5 "2019-07-18T23:36:42Z")

</div>

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