# Kibana table using data histogram aggregation resulting in counts with decimals

**URL:** <https://discuss.elastic.co/t/kibana-table-using-data-histogram-aggregation-resulting-in-counts-with-decimals/269249>\
**Category:** Kibana\
**Created:** [April 5, 2021, 4:56pm UTC](https://discuss.elastic.co/t/kibana-table-using-data-histogram-aggregation-resulting-in-counts-with-decimals/269249 "2021-04-05T16:56:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Amphagory](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/amphagory/32/46127_2.png) [@Amphagory](https://discuss.elastic.co/u/Amphagory)\
**Post date:** [April 5, 2021, 4:56pm UTC](https://discuss.elastic.co/t/kibana-table-using-data-histogram-aggregation-resulting-in-counts-with-decimals/269249/1 "2021-04-05T16:56:19Z")

</div>

Hello,

I'm using Kibana 7.3.2 where I'm create a simple count table using data histogram aggregation to split the rows into buckets. I am using the timestamp for each event and set the interval to 60 minutes and the initial time range to the past 24 hours.

Everything looks good:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/3/c32a2fac722f0dbd0ff2594c9fd8d31fb936f51a.png)

Now if I change the time range to the past month, a couple changes occur in the table:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/8/28c8f03b520868364b48722b3ebe63f8eceaa570.png)

Issues:

1. I get decimals in the count (I would have expected only whole numbers here)
2. The buckets are now intervals of 3 hours instead of 1 hour.

I was wonder if someone could enlighten me on specifically issue 1.

Thanks,  
Mike

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [April 5, 2021, 5:08pm UTC](https://discuss.elastic.co/t/kibana-table-using-data-histogram-aggregation-resulting-in-counts-with-decimals/269249/2 "2021-04-05T17:08:41Z")

</div>

This behavior frequently confused users before Kibana 7.5 was released in December 2019. The version of the software you're using is nearly 2 years old. Here is the issue describing what you are seeing:

> <https://github.com/elastic/kibana/issues/42611>
>
> Kibana currently has some implicit value scaling. This works as following:
> If a user selects a manual time range, like "minutes" or...

---

<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 3, 2021, 5:09pm UTC](https://discuss.elastic.co/t/kibana-table-using-data-histogram-aggregation-resulting-in-counts-with-decimals/269249/3 "2021-05-03T17:09:39Z")

</div>

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