# Any idea why I can't get an Average on a float type field when I want to visualize my data?

**URL:** <https://discuss.elastic.co/t/any-idea-why-i-cant-get-an-average-on-a-float-type-field-when-i-want-to-visualize-my-data/41980>\
**Category:** Kibana\
**Created:** [February 17, 2016, 7:27am UTC](https://discuss.elastic.co/t/any-idea-why-i-cant-get-an-average-on-a-float-type-field-when-i-want-to-visualize-my-data/41980 "2016-02-17T07:27:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![teewhey](https://avatars.discourse-cdn.com/v4/letter/t/8797f3/32.png) [@teewhey](https://discuss.elastic.co/u/teewhey)\
**Post date:** [February 17, 2016, 7:27am UTC](https://discuss.elastic.co/t/any-idea-why-i-cant-get-an-average-on-a-float-type-field-when-i-want-to-visualize-my-data/41980/1 "2016-02-17T07:27:51Z")

</div>

Any idea why can't Kibana get an Average on a float type field when I want to visualize my data?

I got this error when trying to select Average on one of my field.

> Visualize: Expected numeric type on field [request\_time], but got [float]

A sample data for request\_time is 0.12, 1.04, 0.78, so on and so forth. I find it weird for Kibana to behave this way.

---

<div class="post-metadata">

**Author:** ![teewhey](https://avatars.discourse-cdn.com/v4/letter/t/8797f3/32.png) [@teewhey](https://discuss.elastic.co/u/teewhey)\
**Post date:** [February 17, 2016, 7:41am UTC](https://discuss.elastic.co/t/any-idea-why-i-cant-get-an-average-on-a-float-type-field-when-i-want-to-visualize-my-data/41980/2 "2016-02-17T07:41:27Z")

</div>

Found out the issue.  
I have gone to the FIeld Formatter and picked "Number" as the format for my field and now I'm able to get an average of it.

---

<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:** [July 6, 2017, 2:02pm UTC](https://discuss.elastic.co/t/any-idea-why-i-cant-get-an-average-on-a-float-type-field-when-i-want-to-visualize-my-data/41980/3 "2017-07-06T14:02:04Z")

</div>