# Format numbers in metric aggregation

**URL:** <https://discuss.elastic.co/t/format-numbers-in-metric-aggregation/71338>\
**Category:** Kibana\
**Created:** [January 12, 2017, 8:26am UTC](https://discuss.elastic.co/t/format-numbers-in-metric-aggregation/71338 "2017-01-12T08:26:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tal\_Weiss](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tal_weiss/32/13021_2.png) [@Tal\_Weiss](https://discuss.elastic.co/u/Tal_Weiss)\
**Post date:** [January 12, 2017, 8:26am UTC](https://discuss.elastic.co/t/format-numbers-in-metric-aggregation/71338/1 "2017-01-12T08:26:45Z")

</div>

I added an average metric aggregation to my Kibana and it works.  
But it looks like this:  
Average satisfaction: 4.53030303030303  
Is there a way to round off to a single decimal digit?  
The general question is - can I format the resulting number?  
I'm running the latest Kibana / ES stack on your cloud BTW.

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [January 12, 2017, 11:16pm UTC](https://discuss.elastic.co/t/format-numbers-in-metric-aggregation/71338/2 "2017-01-12T23:16:01Z")

</div>

Yes. If you go to Management, then Index Patterns, you'll see a list of fields, and you can click on the edit icon and choose a custom formatter, one of which is "Number", which lets you select how many decimal points you'd like to display. Hope this helps!

---

<div class="post-metadata">

**Author:** ![Tal\_Weiss](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tal_weiss/32/13021_2.png) [@Tal\_Weiss](https://discuss.elastic.co/u/Tal_Weiss)\
**Post date:** [January 13, 2017, 3:49pm UTC](https://discuss.elastic.co/t/format-numbers-in-metric-aggregation/71338/3 "2017-01-13T15:49:43Z")

</div>

Hi Lukas,

Thanks for the reply - this is **exactly** what I need BUT FOR A METRIC AGGREGATION (a visualization) and **not** for a specific field.  
I averaged a bunch of numbers and I get the 10 decimal places float.

---

<div class="post-metadata">

**Author:** ![Tal\_Weiss](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tal_weiss/32/13021_2.png) [@Tal\_Weiss](https://discuss.elastic.co/u/Tal_Weiss)\
**Post date:** [January 16, 2017, 12:12pm UTC](https://discuss.elastic.co/t/format-numbers-in-metric-aggregation/71338/4 "2017-01-16T12:12:17Z")

</div>

Wow - it works for the average as well - thanks!!!

---

<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:** [February 13, 2017, 12:12pm UTC](https://discuss.elastic.co/t/format-numbers-in-metric-aggregation/71338/5 "2017-02-13T12:12:29Z")

</div>

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