Script - round an average

[simple_commentateur]

Hello,

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

Average value : 24573.222

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

[simple_commentateur]

EDIT :

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

[simple_commentateur]

Any one have a solution?

[rjernst (Ryan Ernst)]

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