# Overall Average of count returns float value need Integer **URL:** \ **Category:** Kibana\ **Created:** [February 20, 2020, 9:38pm UTC](https://discuss.elastic.co/t/overall-average-of-count-returns-float-value-need-integer/220271 "2020-02-20T21:38:11Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![vikasp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikasp/32/90872_2.png) [@vikasp](https://discuss.elastic.co/u/vikasp)\ **Post date:** [February 20, 2020, 9:38pm UTC](https://discuss.elastic.co/t/overall-average-of-count-returns-float-value-need-integer/220271/1 "2020-02-20T21:38:12Z")
Hi, I created a Kibana visualization (data table) that will give the overall average of the count of the messages split by rows (for the values in status.keyword). I am getting an average value fine and good for the selected time range. But I am getting a float value. My team requires it to be a number. I have gone through some pages in discuss, so far I only found to modify the datatype of a field. In my case, I am trying to find the average of count of messages. Please let me know If I can do that. ---
**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\ **Post date:** [February 24, 2020, 11:26pm UTC](https://discuss.elastic.co/t/overall-average-of-count-returns-float-value-need-integer/220271/2 "2020-02-24T23:26:04Z")
Sorry, I don't know what "average of the count" is. Could you say more about the visualization? Are you using average bucket aggregation as a metric? ---
**Author:** ![vikasp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikasp/32/90872_2.png) [@vikasp](https://discuss.elastic.co/u/vikasp)\ **Post date:** [February 25, 2020, 7:04am UTC](https://discuss.elastic.co/t/overall-average-of-count-returns-float-value-need-integer/220271/3 "2020-02-25T07:04:56Z")
Yes, I am using Average Bucket as a Metric Aggregation. Here is the attachment just to be sure. ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/e/fe983fdeab55ae4955407f7fd4c250f519550817.png) ---
**Author:** ![vikasp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikasp/32/90872_2.png) [@vikasp](https://discuss.elastic.co/u/vikasp)\ **Post date:** [March 3, 2020, 7:58pm UTC](https://discuss.elastic.co/t/overall-average-of-count-returns-float-value-need-integer/220271/4 "2020-03-03T19:58:24Z")
Can we do this, do you have any idea on how to do this. Please let me know. Thanks ---
**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\ **Post date:** [March 9, 2020, 7:43pm UTC](https://discuss.elastic.co/t/overall-average-of-count-returns-float-value-need-integer/220271/5 "2020-03-09T19:43:07Z")
Sorry, I checked around and it looks like it is not possible, unfortunately. ---
**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\ **Post date:** [March 9, 2020, 8:29pm UTC](https://discuss.elastic.co/t/overall-average-of-count-returns-float-value-need-integer/220271/6 "2020-03-09T20:29:05Z")
Quick update, in looking into this question, I found a possible issue in Kibana, which may be blocking the desired behavior: [https://github.com/elastic/kibana/issues/59703](https://github.com/elastic/kibana/issues/59703) ---
**Author:** ![vikasp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikasp/32/90872_2.png) [@vikasp](https://discuss.elastic.co/u/vikasp)\ **Post date:** [March 9, 2020, 11:31pm UTC](https://discuss.elastic.co/t/overall-average-of-count-returns-float-value-need-integer/220271/7 "2020-03-09T23:31:31Z")
Thanks for the update ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 6, 2020, 11:31pm UTC](https://discuss.elastic.co/t/overall-average-of-count-returns-float-value-need-integer/220271/8 "2020-04-06T23:31:38Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.