# Unable to visualise long text field in Kibana

**URL:** <https://discuss.elastic.co/t/unable-to-visualise-long-text-field-in-kibana/258597>\
**Category:** Kibana\
**Created:** [December 14, 2020, 3:25pm UTC](https://discuss.elastic.co/t/unable-to-visualise-long-text-field-in-kibana/258597 "2020-12-14T15:25:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![tarund](https://avatars.discourse-cdn.com/v4/letter/t/977dab/32.png) [@tarund](https://discuss.elastic.co/u/tarund)\
**Post date:** [December 14, 2020, 3:25pm UTC](https://discuss.elastic.co/t/unable-to-visualise-long-text-field-in-kibana/258597/1 "2020-12-14T15:25:51Z")

</div>

Hi ,

I have an index in Elasticsearch in which one of the text fields(qtext) has values like below -

```auto
{ delete: "UsDetails", ordered: true, txnNumber: 381, $db: "apt", $clusterTime: { clusterTime: Timestamp(1607955967, 25), signature: { hash: BinData(0, A1E67538EDDC0E21C81960AF287), keyId: 688361470713454228204 } }, lsid: { id: UUID("12ac052a-2344-1112-ac97-b0bf6b58d3de") } }

```

I am trying to create a visualization in Kibana - aggregate metric count, group by the above field(qtext). But it does not work, it does not give any error, just says 'No Data to display'  
The field is searchable and aggregatable.

Is it due to special characters in the field or just that the field is too large or how can I do aggregations on this field ?

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [December 14, 2020, 7:48pm UTC](https://discuss.elastic.co/t/unable-to-visualise-long-text-field-in-kibana/258597/2 "2020-12-14T19:48:52Z")

</div>

If it says "no data to display", then typically it means that the filters on your visualization haven't matched any documents. It's not related to special characters or aggregations. Are you sure that your configuration will match documents?

---

<div class="post-metadata">

**Author:** ![tarund](https://avatars.discourse-cdn.com/v4/letter/t/977dab/32.png) [@tarund](https://discuss.elastic.co/u/tarund)\
**Post date:** [December 15, 2020, 3:48am UTC](https://discuss.elastic.co/t/unable-to-visualise-long-text-field-in-kibana/258597/3 "2020-12-15T03:48:25Z")

</div>

Yes, documents are present, can be seen under discover tab. Moreover, there are no filters, if I aggregate by other fields, data shows up, but it doesn't work with the long text field.  
Just trying to get the count of documents group'd by the text field.

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [December 15, 2020, 2:43pm UTC](https://discuss.elastic.co/t/unable-to-visualise-long-text-field-in-kibana/258597/4 "2020-12-15T14:43:15Z")

</div>

If you're sure it's not related to the filters then it's not obvious from your question what the problem is. You can try looking at the Inspect menu to show what the actual Elasticsearch request is, and you can see if that request matches what you think is happening. Another option is to look at the mappings of your documents and make sure they are mapped correctly.

---

<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:** [January 12, 2021, 2:43pm UTC](https://discuss.elastic.co/t/unable-to-visualise-long-text-field-in-kibana/258597/5 "2021-01-12T14:43:21Z")

</div>

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