# Kibana 4.1 metric visualization round decimal value
**URL:** https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098
**Category:** Kibana
**Created:** [June 22, 2015, 2:33pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098 "2015-06-22T14:33:23Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@rajeshchinnam1985](https://discuss.elastic.co/u/rajeshchinnam1985)
#### Post date: [June 22, 2015, 2:33pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/1 "2015-06-22T14:33:23Z")
Thanks in advance..
I am using kibana 4.1 and trying to create a metric visualization which returning me a value of 135.649
how can I round off this value 135.65
How can I do this
---
### Author:  [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [June 22, 2015, 6:21pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/2 "2015-06-22T18:21:28Z")
Indeed, documentation on field formatters in 4.1 is light (I just logged [issue 4299](https://github.com/elastic/kibana/issues/4299) to improve it).
To accomplish number formatting in 4.1, you can do the following:
- In Settings, go to the index with the field in question
- On the right-hand side under "Controls" column click the Edit icon next to the field you want to format
- If it's a numeric field, in the "Format" dropdown you'll see "Number" as one of the options
- Change the default to the following [numeral.js](http://numeraljs.com/) pattern 0,0.[00]
- Click Update Field
After this, all visualizations using this field will only show two decimal points.
---
### Author:  [@Phani\_Nadiminti](https://discuss.elastic.co/u/Phani_Nadiminti)
#### Post date: [July 14, 2015, 5:42am UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/3 "2015-07-14T05:42:28Z")
Hi Tanya,
yes with this procedure we can decrease precession but how to round value to the nearest integer using script field functions
I have a netamt value which is of double type now I want to round it to nearest integer value i used the following function in scripted fields in kibana 4.1.1.
Used following scripting calculation to round the value. round(doc['netamt'].value)
I am getting error like undefined method "round" so please suggest me how to apply round function or suitable function to get nearest integer value in kibana.
Thanks,
phani
---
### Author:  [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [July 14, 2015, 12:31pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/4 "2015-07-14T12:31:53Z")
"round" is not a supported function in [Lucene Expressions](http://lucene.apache.org/core/4_9_0/expressions/index.html?org/apache/lucene/expressions/js/package-summary.html), which is the default scripting language in Kibana scripted fields.
As mentioned above, field formatters can be combined with scripted metrics, so you should use that to customize the display. To round to the nearest integer, just use '0' or '0,0' as your [numeral.js](http://numeraljs.com/) pattern.
---
### Author:  [@Phani\_Nadiminti](https://discuss.elastic.co/u/Phani_Nadiminti)
#### Post date: [July 14, 2015, 1:45pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/5 "2015-07-14T13:45:13Z")
Hi Tanya
Thank you for quick reply.I tried the logic which you have mentioned in numeral.js pattern but it is rounding only some values not all.any other function we can apply to round to nearest integer..please suggest me next procedure to achieve that one.
Thanks
phani
---
### Author:  [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [July 14, 2015, 2:22pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/6 "2015-07-14T14:22:06Z")
Interesting. Could you share some screenshots of your configuration and results of those in terms of not rounding values?
---
### Author:  [@Phani\_Nadiminti](https://discuss.elastic.co/u/Phani_Nadiminti)
#### Post date: [July 15, 2015, 5:29am UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/7 "2015-07-15T05:29:36Z")
Yeah sure.please find the following value table where i am calculating netamounts.
In database I am using round function .Please find the attached configuration screen shot of netamt in kibana
please suggest me where i am going wrong here?
Thanks,
phani
---
### Author:  [@Chris\_Blackwell](https://discuss.elastic.co/u/Chris_Blackwell)
#### Post date: [September 15, 2015, 8:58am UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/8 "2015-09-15T08:58:19Z")
Whats really needed here is format pattern thats applied only to the metric visualisation.
We have events with numeric values stored with 5 decimal places (for example 0.02340) so need to retain precision, but when we sum them over thousands of events to display as a metric I just want to display an integer value.
---
### Author:  [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [September 26, 2015, 1:11pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/9 "2015-09-26T13:11:37Z")
Indeed - we are tracking this as an enhancement on Github: [https://github.com/elastic/kibana/issues/4957](https://github.com/elastic/kibana/issues/4957)
---
### Author:  [@kalabakas](https://discuss.elastic.co/u/kalabakas)
#### Post date: [September 30, 2015, 12:49pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/10 "2015-09-30T12:49:01Z")
Hi Tanya,
in our index there is a field having values 0 or 1.
All I want is to present the average in a metric visualization.
The issue is that the result is like "0.9346090399208182" and cannot find how to round that value...
Already tried to set format as Number but no change.
Is this the same case as in the issue mentioned above?
---
### Author:  [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [October 6, 2015, 3:43am UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/11 "2015-10-06T03:43:15Z")
Not really. Could you post your visualization config and field formatter config in screenshots?
---
### Author:  [@kalabakas](https://discuss.elastic.co/u/kalabakas)
#### Post date: [October 13, 2015, 7:25am UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/12 "2015-10-13T07:25:38Z")
There is a field named "foo".
Field formatter: Type=number, Numeral.js format pattern = 0,0.[00]
Visualization: Metric, Aggregation: Average, Field: "foo".
The issue is that the average output is "0.9346090399208182" instead of "0.93".
---
### Author:  [@JuanCarniglia](https://discuss.elastic.co/u/JuanCarniglia)
#### Post date: [October 30, 2015, 2:45pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/13 "2015-10-30T14:45:58Z")
Hi! Ever solved this? I am battling the same foe...
Thanks!
---
### Author:  [@Vinuja1](https://discuss.elastic.co/u/Vinuja1)
#### Post date: [June 16, 2017, 10:05pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/14 "2017-06-16T22:05:11Z")
I have the same issue. Do you find something?
I tried to set format as Number but no change.
---
### Author:  [@Vinuja1](https://discuss.elastic.co/u/Vinuja1)
#### Post date: [June 19, 2017, 12:44pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/15 "2017-06-19T12:44:11Z")
ps: I am using Kibana extended metric in kibana 5.
Do someone had the same issue?
---
### Author:  [@vinay.t](https://discuss.elastic.co/u/vinay.t)
#### Post date: [August 9, 2017, 7:45am UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/16 "2017-08-09T07:45:51Z")
Hi,
I got the same requirement,
How to achieve this on 5.5 Version, Please provide steps.
Regards
Vinay
---
### Author:  [@jcardone](https://discuss.elastic.co/u/jcardone)
#### Post date: [September 8, 2017, 6:03pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/17 "2017-09-08T18:03:48Z")
Hi,
I have the same issue, someone solved this?,
Thanks!!
---
### Author:  [@gmoskovicz](https://discuss.elastic.co/u/gmoskovicz)
#### Post date: [November 29, 2017, 7:02pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/18 "2017-11-29T19:02:04Z")
I think that Visual Builder can accomplish this easily by configuring the right formatter (with Number.js):
You can format any number as you wish.
Thanks!
--Gabriel
---
### Author:  [@vaishali1](https://discuss.elastic.co/u/vaishali1)
#### Post date: [March 6, 2018, 2:27pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/19 "2018-03-06T14:27:08Z")
> [@tbragin](#):
>
> **0,0.[00]**
Thank you, it worked for me
---
### Author:  [@Surupa\_Ray](https://discuss.elastic.co/u/Surupa_Ray)
#### Post date: [April 3, 2020, 10:40am UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098/20 "2020-04-03T10:40:12Z")
As I am using AWS Elasticsearch, I do not have option to use any third party plugins.
I need to round off the decimal values of the values in a visualization which are generated using Average aggregation. Hence formatting the field in Settings page would not help.
[Next page](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098.md?page=2)