# Can not make aggregations to work on string field (ES 5.5.1)

**URL:** <https://discuss.elastic.co/t/can-not-make-aggregations-to-work-on-string-field-es-5-5-1/101551>\
**Category:** Kibana\
**Created:** [September 23, 2017, 12:37am UTC](https://discuss.elastic.co/t/can-not-make-aggregations-to-work-on-string-field-es-5-5-1/101551 "2017-09-23T00:37:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![zzvara](https://avatars.discourse-cdn.com/v4/letter/z/50afbb/32.png) [@zzvara](https://discuss.elastic.co/u/zzvara)\
**Post date:** [September 23, 2017, 12:37am UTC](https://discuss.elastic.co/t/can-not-make-aggregations-to-work-on-string-field-es-5-5-1/101551/1 "2017-09-23T00:37:52Z")

</div>

Dear Community,

I have made a small fun PoC last year, 2016. December 18th, on which I inserted tweets (Twitter4J) into ES, and visualized with Kibana.

![image](https://us1.discourse-cdn.com/elastic/original/3X/3/4/3442a8de9280d764254577229770e4c73f790916.png)

The above visualization shows significant terms that appear in tweets that contain "trump", and on the Y axis, their corresponding sentiment value. I prepared no mappings by hand, fields have been indexed dynamically and appeared in Kibana - surprisingly and fortunately.

Now, using the same data, I would like to define my own mappings, but could not produce the same visualization. The "tweet.text" if analyzed, no aggregations are available. If I create a "raw" field mapping as well, it is aggregatable, but definitely not going to produce the same results. I also added the following to the field definition:

```
"term_vector": "with_positions_offsets_payloads",
"index_options": "offsets"

```

I'm using the "standard" analyzer, and field type "text".

I kindly as the Community to help me to achieve such a visualization on any text field.

Cheers,  
Zoltán

---

<div class="post-metadata">

**Author:** ![zzvara](https://avatars.discourse-cdn.com/v4/letter/z/50afbb/32.png) [@zzvara](https://discuss.elastic.co/u/zzvara)\
**Post date:** [September 23, 2017, 1:12pm UTC](https://discuss.elastic.co/t/can-not-make-aggregations-to-work-on-string-field-es-5-5-1/101551/2 "2017-09-23T13:12:07Z")

</div>

It seems to me that aggregations on analyzed string fields have been removed. The following is a working example from Kibana 5.0.0-alpha4.

 ![Terms 2](https://us1.discourse-cdn.com/elastic/original/3X/5/0/50f86bcc42211a6fc531071675531bdc567c1875.JPG)

This can not be done in Kibana 5.5.1.

I would be happy to receive a conformation from the Community, that this functionality has been removed from Kibana.

---

<div class="post-metadata">

**Author:** ![Barnabas\_Balazs](https://avatars.discourse-cdn.com/v4/letter/b/9dc877/32.png) [@Barnabas\_Balazs](https://discuss.elastic.co/u/Barnabas_Balazs)\
**Post date:** [September 23, 2017, 1:38pm UTC](https://discuss.elastic.co/t/can-not-make-aggregations-to-work-on-string-field-es-5-5-1/101551/3 "2017-09-23T13:38:38Z")

</div>

This feature would be nice to have for my application too, I hope this issue will be fixed soon.

---

<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:** [October 21, 2017, 1:39pm UTC](https://discuss.elastic.co/t/can-not-make-aggregations-to-work-on-string-field-es-5-5-1/101551/4 "2017-10-21T13:39:03Z")

</div>

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