# Can't use average agg on number lower than 1

**URL:** <https://discuss.elastic.co/t/cant-use-average-agg-on-number-lower-than-1/303091>\
**Category:** Kibana\
**Created:** [April 24, 2022, 9:19am UTC](https://discuss.elastic.co/t/cant-use-average-agg-on-number-lower-than-1/303091 "2022-04-24T09:19:14Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![xxk](https://avatars.discourse-cdn.com/v4/letter/x/34f0e0/32.png) [@xxk](https://discuss.elastic.co/u/xxk)\
**Post date:** [April 24, 2022, 9:19am UTC](https://discuss.elastic.co/t/cant-use-average-agg-on-number-lower-than-1/303091/1 "2022-04-24T09:19:14Z")

</div>

I have a field pctr which values are all between (0,1).  
But i can't use average agg on pctr in visualize

---

<div class="post-metadata">

**Author:** ![xxk](https://avatars.discourse-cdn.com/v4/letter/x/34f0e0/32.png) [@xxk](https://discuss.elastic.co/u/xxk)\
**Post date:** [April 24, 2022, 9:35am UTC](https://discuss.elastic.co/t/cant-use-average-agg-on-number-lower-than-1/303091/2 "2022-04-24T09:35:56Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [April 25, 2022, 7:18am UTC](https://discuss.elastic.co/t/cant-use-average-agg-on-number-lower-than-1/303091/3 "2022-04-25T07:18:22Z")

</div>

Most likely the `pctr` field is mapped as an integer field, so everything after the decimal point isn't saved to the index. Change the type in the mapping to float or double and re-index your data.

---

<div class="post-metadata">

**Author:** ![xxk](https://avatars.discourse-cdn.com/v4/letter/x/34f0e0/32.png) [@xxk](https://discuss.elastic.co/u/xxk)\
**Post date:** [April 26, 2022, 2:41am UTC](https://discuss.elastic.co/t/cant-use-average-agg-on-number-lower-than-1/303091/4 "2022-04-26T02:41:33Z")

</div>

But on the discovery page, the **pctr** shows as double.By the way, **pctr** use dynamic mapping.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [April 26, 2022, 2:58am UTC](https://discuss.elastic.co/t/cant-use-average-agg-on-number-lower-than-1/303091/5 "2022-04-26T02:58:18Z")

</div>

Can you show us the mapping?

---

<div class="post-metadata">

**Author:** ![xxk](https://avatars.discourse-cdn.com/v4/letter/x/34f0e0/32.png) [@xxk](https://discuss.elastic.co/u/xxk)\
**Post date:** [April 26, 2022, 7:07am UTC](https://discuss.elastic.co/t/cant-use-average-agg-on-number-lower-than-1/303091/6 "2022-04-26T07:07:48Z")

</div>

Thank you.It works now.  
I forgot refresh index after changing mapping.

---

<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 24, 2022, 7:08am UTC](https://discuss.elastic.co/t/cant-use-average-agg-on-number-lower-than-1/303091/7 "2022-05-24T07:08:10Z")

</div>

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