# Kibana Word Cloud on Text Field **URL:** \ **Category:** Kibana\ **Created:** [September 30, 2020, 2:33pm UTC](https://discuss.elastic.co/t/kibana-word-cloud-on-text-field/250523 "2020-09-30T14:33:05Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![spyderman4g63](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spyderman4g63/32/64172_2.png) [@spyderman4g63](https://discuss.elastic.co/u/spyderman4g63)\ **Post date:** [September 30, 2020, 2:33pm UTC](https://discuss.elastic.co/t/kibana-word-cloud-on-text-field/250523/1 "2020-09-30T14:33:05Z")
I'm trying to create a word cloud on a text field called "message". This is my configuration for the field in elasticsearch: ```auto { "my_index" : { "mappings" : { "message" : { "full_name" : "message", "mapping" : { "message" : { "type" : "text", "fields" : { "keyword" : { "type" : "keyword", "ignore_above" : 256 } }, "fielddata" : true } } } } } } ``` In kibana, I don't have an option for "message", but I do see an option for "message.keyword" however, it shows no data. Other fields like "type.keyword" seem to work. Is there something wrong with my configuration for the "message" text field? ---
**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:** [September 30, 2020, 3:26pm UTC](https://discuss.elastic.co/t/kibana-word-cloud-on-text-field/250523/2 "2020-09-30T15:26:03Z")
Are the values of `message` longer than 256 characters? In that case they wouldn't be indexed. ---
**Author:** ![spyderman4g63](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spyderman4g63/32/64172_2.png) [@spyderman4g63](https://discuss.elastic.co/u/spyderman4g63)\ **Post date:** [September 30, 2020, 3:33pm UTC](https://discuss.elastic.co/t/kibana-word-cloud-on-text-field/250523/3 "2020-09-30T15:33:25Z")
Oh yes, way larger. ---
**Author:** ![spyderman4g63](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spyderman4g63/32/64172_2.png) [@spyderman4g63](https://discuss.elastic.co/u/spyderman4g63)\ **Post date:** [September 30, 2020, 3:45pm UTC](https://discuss.elastic.co/t/kibana-word-cloud-on-text-field/250523/4 "2020-09-30T15:45:44Z")
Is there a limit to `ignore_above` and is it a bad idea to make it very large? edit: I tried creating a field with a super large limit just to see if it would work: ```auto { "mappings": { "properties": { "message": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above" : 100000000 } } } } } } ``` It didn't work. It seems like lucene might have a limit of `8191 characters` according to [this documentation.](https://www.elastic.co/guide/en/elasticsearch/reference/current/ignore-above.html) ---
**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:** [October 1, 2020, 12:53pm UTC](https://discuss.elastic.co/t/kibana-word-cloud-on-text-field/250523/5 "2020-10-01T12:53:59Z")
Can you elaborate on your use case? I can't see how a word cloud would render nicely with such large terms. Maybe there is another way to achieve your goal. ---
**Author:** ![spyderman4g63](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spyderman4g63/32/64172_2.png) [@spyderman4g63](https://discuss.elastic.co/u/spyderman4g63)\ **Post date:** [October 1, 2020, 1:36pm UTC](https://discuss.elastic.co/t/kibana-word-cloud-on-text-field/250523/6 "2020-10-01T13:36:23Z")
I was looking to extract some of the most commonly used terms from a document. ---
**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:** [October 1, 2020, 1:40pm UTC](https://discuss.elastic.co/t/kibana-word-cloud-on-text-field/250523/7 "2020-10-01T13:40:31Z")
I see, that's not what the terms aggregation will do - it will match the whole message as a single value (so I guess each one will occur exactly once) - e.g. "This is a very very long message" is a single term, it won't split "This" and "very" and so on. I think using "significant terms" on the text field (`message`, not `message.keyword`) is what you want - it show you words commonly used in the message field ---
**Author:** ![spyderman4g63](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spyderman4g63/32/64172_2.png) [@spyderman4g63](https://discuss.elastic.co/u/spyderman4g63)\ **Post date:** [October 1, 2020, 2:03pm UTC](https://discuss.elastic.co/t/kibana-word-cloud-on-text-field/250523/8 "2020-10-01T14:03:32Z")
Ah, I must have been confused. One final question. `message` doesn't show up in the kibana dropdown. I tried turning on `fielddata` but that didn't seem to work. Any idea on why it wouldn't appear in kibana? Thanks for all the help. Edit: i saw that the field wasn't aggregateable in the in the index patterns. I delete and readded the pattern and it says `message` is aggregatable and shows up iin kibana but still doesn't extract any significant terms. ---
**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:** [October 1, 2020, 3:02pm UTC](https://discuss.elastic.co/t/kibana-word-cloud-on-text-field/250523/9 "2020-10-01T15:02:17Z")
Ah, I made a mistake here as well. A bunch of things to clear up: - On changing the mapping you need to refresh the index pattern in Kibana so it can pick up the changes (recreating works as well) - In your case "Terms" is probably the right thing, if used on a "text" field with fielddata enabled it does what you expect (showing the most common words in your document) - significant terms is just a special case of that highlighting unusually common terms in relation to your current query (doesn't make much sense without a query) - How did you turn on fielddata? You might need to reindex your data so it's properly populated An example that worked for me: - Create the mapping and ingest data ```auto PUT textindex2 { "mappings": { "properties": { "message": { "type": "text", "fielddata": true } } } } POST textindex2/_doc { "message": "This is my message" } POST textindex2/_doc { "message": "This is my other message" } ``` - Create index pattern for this index - Create tag cloud based on "terms" aggregation on the message field ![Screenshot 2020-10-01 at 17.01.08](https://us1.discourse-cdn.com/elastic/original/3X/4/b/4be57f2cc5f36badccfff12c4893fcc3dc37d181.png) ---
**Author:** ![spyderman4g63](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spyderman4g63/32/64172_2.png) [@spyderman4g63](https://discuss.elastic.co/u/spyderman4g63)\ **Post date:** [October 1, 2020, 3:28pm UTC](https://discuss.elastic.co/t/kibana-word-cloud-on-text-field/250523/10 "2020-10-01T15:28:44Z")
Thank you again. I had to re-index my data. The `terms` aggregation works now. It's not very helpful since the top terms are random numbers and things but I guess that is expected. ---
**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:** [October 2, 2020, 7:21am UTC](https://discuss.elastic.co/t/kibana-word-cloud-on-text-field/250523/11 "2020-10-02T07:21:16Z")
The values ending up in the index depend on the mapping - you can configure the used token filters to exclude certain values (e.g. the `stop` filter to exclude values from a list: [https://www.elastic.co/guide/en/elasticsearch/reference/current/analysis-stop-tokenfilter.html#analysis-stop-tokenfilter-customize](https://www.elastic.co/guide/en/elasticsearch/reference/current/analysis-stop-tokenfilter.html#analysis-stop-tokenfilter-customize)) - check out the side bar on the same page, there are a lot of options to clean it up. If you change the mapping, you have to reindex your data for it to take effect. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [October 30, 2020, 7:21am UTC](https://discuss.elastic.co/t/kibana-word-cloud-on-text-field/250523/12 "2020-10-30T07:21:18Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.