Kibana table using data histogram aggregation resulting in counts with decimals

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:

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

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

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:

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