# Kibana average showing it in percentage

**URL:** https://discuss.elastic.co/t/kibana-average-showing-it-in-percentage/212869
**Category:** Kibana
**Created:** [December 23, 2019, 4:24pm UTC](https://discuss.elastic.co/t/kibana-average-showing-it-in-percentage/212869 "2019-12-23T16:24:24Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Sergioc](https://avatars.discourse-cdn.com/v4/letter/s/67e7ee/32.png) [@Sergioc](https://discuss.elastic.co/u/Sergioc)
#### Post date: [December 23, 2019, 4:24pm UTC](https://discuss.elastic.co/t/kibana-average-showing-it-in-percentage/212869/1 "2019-12-23T16:24:24Z")

</div>

Is there any way to show the average metric in percentage in Kibana?

 ![Capture](https://us1.discourse-cdn.com/elastic/original/3X/6/c/6c9b0ec26e3244805c97b507b46e09e4cb558862.jpeg)

if you see the numbers are 0.078 I would like them to be like 7.8% for example.

Thank you all

---

<div class="post-metadata">

### Author: ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)
#### Post date: [December 23, 2019, 11:20pm UTC](https://discuss.elastic.co/t/kibana-average-showing-it-in-percentage/212869/2 "2019-12-23T23:20:02Z")

</div>

Hello,

You can use field formatters to do this:  
[https://www.elastic.co/guide/en/kibana/current/field-formatters-numeric.html](https://www.elastic.co/guide/en/kibana/current/field-formatters-numeric.html)

Thanks,  
Bhavya

---

<div class="post-metadata">

### Author: ![Sergioc](https://avatars.discourse-cdn.com/v4/letter/s/67e7ee/32.png) [@Sergioc](https://discuss.elastic.co/u/Sergioc)
#### Post date: [December 26, 2019, 4:03pm UTC](https://discuss.elastic.co/t/kibana-average-showing-it-in-percentage/212869/3 "2019-12-26T16:03:31Z")

</div>

Thank you I will take a look to that now. Thanks

---

<div class="post-metadata">

### Author: ![Sergioc](https://avatars.discourse-cdn.com/v4/letter/s/67e7ee/32.png) [@Sergioc](https://discuss.elastic.co/u/Sergioc)
#### Post date: [December 26, 2019, 4:09pm UTC](https://discuss.elastic.co/t/kibana-average-showing-it-in-percentage/212869/4 "2019-12-26T16:09:33Z")

</div>

Hello, I was reading about the field formatting and it looks like it applies to the index, so you can take a field in the index and format the field.  
But the graph is not showing a field, it is making an aggregation Average from a field that is numeric and once the aggregation is done it shows 0.078 instead of 7.8%.

so the field formatting doesn't work for this scenario.

---

<div class="post-metadata">

### Author: ![Sergioc](https://avatars.discourse-cdn.com/v4/letter/s/67e7ee/32.png) [@Sergioc](https://discuss.elastic.co/u/Sergioc)
#### Post date: [December 26, 2019, 6:38pm UTC](https://discuss.elastic.co/t/kibana-average-showing-it-in-percentage/212869/5 "2019-12-26T18:38:06Z")

</div>

the value i was using was 1 or 0 what i did is i have multiplied the value \* 100 and it works now. Thank you.

---

<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: [January 23, 2020, 6:43pm UTC](https://discuss.elastic.co/t/kibana-average-showing-it-in-percentage/212869/6 "2020-01-23T18:43:28Z")

</div>

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