# Cannot aggregate in visualize section (on 5.3)

**URL:** <https://discuss.elastic.co/t/cannot-aggregate-in-visualize-section-on-5-3/108277>\
**Category:** Kibana\
**Created:** [November 19, 2017, 10:13am UTC](https://discuss.elastic.co/t/cannot-aggregate-in-visualize-section-on-5-3/108277 "2017-11-19T10:13:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MatthD](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matthd/32/22479_2.png) [@MatthD](https://discuss.elastic.co/u/MatthD)\
**Post date:** [November 19, 2017, 10:13am UTC](https://discuss.elastic.co/t/cannot-aggregate-in-visualize-section-on-5-3/108277/1 "2017-11-19T10:13:58Z")

</div>

Hi everyone!

I am trying since a moment to create a data-table on a field that contains long text.  
But I am not able to get what I would (I just want to show the text of this field )

I know I have 6 documents / 1384 that contains string it this fields (and others contain null) but in visualize I cannot select "fields.validationSchemaErrors" only "fields.validationSchemaErrors.raw" and if I aggregate on "fields.validationSchemaErrors.raw" it only show the null elements ..

**In management I have this**

 ![06](https://us1.discourse-cdn.com/elastic/original/3X/8/7/87d36a3b82d3ae34e43aa8a5f42f9d41060cf2d9.png)

**From the discover I can see the field contains text in 6 documents**

 ![09](https://us1.discourse-cdn.com/elastic/original/3X/8/9/899686eadd345cef9facc406660b93e753de73a1.png)

**In the visualize section I have this**

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

Thanks in advance for the help !

---

<div class="post-metadata">

**Author:** ![MatthD](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matthd/32/22479_2.png) [@MatthD](https://discuss.elastic.co/u/MatthD)\
**Post date:** [November 19, 2017, 12:50pm UTC](https://discuss.elastic.co/t/cannot-aggregate-in-visualize-section-on-5-3/108277/2 "2017-11-19T12:50:53Z")

</div>

Ok It seems I found a way:

It's an elasticsearch mapping solution:

First I need to delete the current index.  
Then I specify that the property is "keyword" and not text (t be aggregatable) + add the property "ignore\_above" : 20000 to accept long string.

After that I just refresh the index in management.

If someone has a better solution I am always ok to hear it

---

<div class="post-metadata">

**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\
**Post date:** [November 20, 2017, 5:07pm UTC](https://discuss.elastic.co/t/cannot-aggregate-in-visualize-section-on-5-3/108277/3 "2017-11-20T17:07:39Z")

</div>

Am glad you found a solution. Thanks for posting it here for the benefit of others. I shall also see if there can be more optimized solution for this.

Thanks  
Rashmi

---

<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:** [December 18, 2017, 5:07pm UTC](https://discuss.elastic.co/t/cannot-aggregate-in-visualize-section-on-5-3/108277/4 "2017-12-18T17:07:42Z")

</div>

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