# Cann't Visualize certain term in kibana data table

**URL:** <https://discuss.elastic.co/t/cannt-visualize-certain-term-in-kibana-data-table/72266>\
**Category:** Kibana\
**Created:** [January 20, 2017, 5:01am UTC](https://discuss.elastic.co/t/cannt-visualize-certain-term-in-kibana-data-table/72266 "2017-01-20T05:01:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rex\_Choi](https://avatars.discourse-cdn.com/v4/letter/r/6a8cbe/32.png) [@Rex\_Choi](https://discuss.elastic.co/u/Rex_Choi)\
**Post date:** [January 20, 2017, 5:01am UTC](https://discuss.elastic.co/t/cannt-visualize-certain-term-in-kibana-data-table/72266/1 "2017-01-20T05:01:41Z")

</div>

HI all,  
I would like to list the count of certain message / code in kibana data table. In the buckets section, I select aggregation as "Terms" and select the property I would like to count in "Field". It works fine for some terms but not the others.  
[![](https://i.stack.imgur.com/yMmzk.png) ](https://i.stack.imgur.com/yMmzk.png)  
It is okay for "fields.MemberType.raw"  
[![](https://i.stack.imgur.com/lAusQ.png) ](https://i.stack.imgur.com/lAusQ.png)  
No result found if I select "fields.RestApiRequestAndResponse.Response.Message".  
[![](https://i.stack.imgur.com/lxQ63.png) ](https://i.stack.imgur.com/lxQ63.png)  
I can get both fields in discover tag.

Have no idea why no result found ... Any idea or how can I trace what happened? Thanks in advance

---

<div class="post-metadata">

**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\
**Post date:** [January 20, 2017, 9:48pm UTC](https://discuss.elastic.co/t/cannt-visualize-certain-term-in-kibana-data-table/72266/2 "2017-01-20T21:48:41Z")

</div>

> [@Rex\_Choi](#):
>
> fields.RestApiRequestAndResponse.Response.Message

What type of mapping does this have in Elasticsearch? Check what is shows when you use the Elasticsearch mapping API:

```auto
http://localhost:9200/data_index/_mapping/document_type

```

If it is an analyzed string field, you'll be able to do search with it, and can show in Discover, but it won't be shown in any field selector in the Visualization builder because Kibana doesn't support visualizations for analyzed strings. If you need that data shown in a visualization, then the mapping for the field should be a multifield with a `raw` key. See [fields | Elasticsearch Guide [8.11] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/multi-fields.html)

---

<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:** [February 17, 2017, 9:48pm UTC](https://discuss.elastic.co/t/cannt-visualize-certain-term-in-kibana-data-table/72266/3 "2017-02-17T21:48:50Z")

</div>

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