# Round the value Average Bucket Aggregation of Unique Count

**URL:** <https://discuss.elastic.co/t/round-the-value-average-bucket-aggregation-of-unique-count/177342>\
**Category:** Kibana\
**Created:** [April 17, 2019, 4:31pm UTC](https://discuss.elastic.co/t/round-the-value-average-bucket-aggregation-of-unique-count/177342 "2019-04-17T16:31:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rami\_Batal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rami_batal/32/43696_2.png) [@Rami\_Batal](https://discuss.elastic.co/u/Rami_Batal)\
**Post date:** [April 17, 2019, 4:31pm UTC](https://discuss.elastic.co/t/round-the-value-average-bucket-aggregation-of-unique-count/177342/1 "2019-04-17T16:31:06Z")

</div>

Hi,

I would like to display the integer approximation of an Average Bucket Aggregation that is averaging the count of documents in each month of over date histogram.

**Please Note that I am counting the unique values of a keyword field (not a number).**

Here is what I am doing, but I would like to have a rounded value.

 ![07%20PM](https://us1.discourse-cdn.com/elastic/original/3X/5/6/56bcd617cc3478d375013031da3b19a84b1a6c20.png)

---

<div class="post-metadata">

**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\
**Post date:** [April 17, 2019, 10:30pm UTC](https://discuss.elastic.co/t/round-the-value-average-bucket-aggregation-of-unique-count/177342/2 "2019-04-17T22:30:04Z")

</div>

Hi,  
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!

Thanks  
Rashmi

---

<div class="post-metadata">

**Author:** ![Rami\_Batal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rami_batal/32/43696_2.png) [@Rami\_Batal](https://discuss.elastic.co/u/Rami_Batal)\
**Post date:** [April 18, 2019, 9:03am UTC](https://discuss.elastic.co/t/round-the-value-average-bucket-aggregation-of-unique-count/177342/3 "2019-04-18T09:03:37Z")

</div>

Thanks Rashmi,

My issue is that I am counting is a keyword field, not a number.

Here is what I am seeing when I follow the instructions, there is no custom formatter option.

 ![56%20AM](https://us1.discourse-cdn.com/elastic/original/3X/c/5/c53f15b4a43e6df30d3b6672c8da9c10c85f1777.png)

Thanks,  
Rami

---

<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:** [May 16, 2019, 9:04am UTC](https://discuss.elastic.co/t/round-the-value-average-bucket-aggregation-of-unique-count/177342/4 "2019-05-16T09:04:34Z")

</div>

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