# When choose "average" function as an aggregation,there are 3 digits after decimal point in kibana page,what should I do if I want to convert the result to integer?thanks

**URL:** <https://discuss.elastic.co/t/when-choose-average-function-as-an-aggregation-there-are-3-digits-after-decimal-point-in-kibana-page-what-should-i-do-if-i-want-to-convert-the-result-to-integer-thanks/150347>\
**Category:** Kibana\
**Created:** [September 28, 2018, 1:17pm UTC](https://discuss.elastic.co/t/when-choose-average-function-as-an-aggregation-there-are-3-digits-after-decimal-point-in-kibana-page-what-should-i-do-if-i-want-to-convert-the-result-to-integer-thanks/150347 "2018-09-28T13:17:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![zcx](https://avatars.discourse-cdn.com/v4/letter/z/e68b1a/32.png) [@zcx](https://discuss.elastic.co/u/zcx)\
**Post date:** [September 28, 2018, 1:17pm UTC](https://discuss.elastic.co/t/when-choose-average-function-as-an-aggregation-there-are-3-digits-after-decimal-point-in-kibana-page-what-should-i-do-if-i-want-to-convert-the-result-to-integer-thanks/150347/1 "2018-09-28T13:17:03Z")

</div>

when choose "average" function as an aggregation,there are 3 digits after decimal point in kibana page,what should I do if I want to convert the result to integer?thanks

---

<div class="post-metadata">

**Author:** ![christophilus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christophilus/32/42991_2.png) [@christophilus](https://discuss.elastic.co/u/christophilus)\
**Post date:** [September 28, 2018, 1:55pm UTC](https://discuss.elastic.co/t/when-choose-average-function-as-an-aggregation-there-are-3-digits-after-decimal-point-in-kibana-page-what-should-i-do-if-i-want-to-convert-the-result-to-integer-thanks/150347/2 "2018-09-28T13:55:12Z")

</div>

There's really not a good way to do that generally, but on a per-visualization basis, you can do things like this. For instance, the gauge visualization allows you to specify "percentage mode", which rounds to an integer.

---

<div class="post-metadata">

**Author:** ![zcx](https://avatars.discourse-cdn.com/v4/letter/z/e68b1a/32.png) [@zcx](https://discuss.elastic.co/u/zcx)\
**Post date:** [September 29, 2018, 2:52am UTC](https://discuss.elastic.co/t/when-choose-average-function-as-an-aggregation-there-are-3-digits-after-decimal-point-in-kibana-page-what-should-i-do-if-i-want-to-convert-the-result-to-integer-thanks/150347/3 "2018-09-29T02:52:50Z")

</div>

Thanks for your reply. And I've test gauge visualization ,as it does as you say. But I need to show data through "Data Table" visualization, cause there are many rows after the aggregation.

---

<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:** [October 27, 2018, 2:52am UTC](https://discuss.elastic.co/t/when-choose-average-function-as-an-aggregation-there-are-3-digits-after-decimal-point-in-kibana-page-what-should-i-do-if-i-want-to-convert-the-result-to-integer-thanks/150347/4 "2018-10-27T02:52:52Z")

</div>

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