# Displaying String (Text) Value in TSVB

**URL:** <https://discuss.elastic.co/t/displaying-string-text-value-in-tsvb/199223>\
**Category:** Kibana\
**Created:** [September 12, 2019, 9:59am UTC](https://discuss.elastic.co/t/displaying-string-text-value-in-tsvb/199223 "2019-09-12T09:59:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![arnim](https://avatars.discourse-cdn.com/v4/letter/a/4da419/32.png) [@arnim](https://discuss.elastic.co/u/arnim)\
**Post date:** [September 12, 2019, 9:59am UTC](https://discuss.elastic.co/t/displaying-string-text-value-in-tsvb/199223/1 "2019-09-12T09:59:14Z")

</div>

Hi,

I would like to create a markdown in TSVB that display the top hit of following data:

query\_id [string]  
longest\_duration [int]  
highest\_concurrent\_transaction [int]

I would like to display all of them in a single visualization at the same time, with the latest data getting displayed. While I could get the integer values, I can't seem to get the string to show up. In TSVB, I can't query the text, instead I could only query the field query\_id.keyword, which shows as "0".

I have also tried grouping them by terms but it seems that I can't just simply get the latest value of query\_id

Any advice on what should I use if I want to visualize something like this?

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [September 12, 2019, 4:29pm UTC](https://discuss.elastic.co/t/displaying-string-text-value-in-tsvb/199223/2 "2019-09-12T16:29:40Z")

</div>

Hmm, playing around with it, I myself can't get anything other than "0" to show up. Seems like a possible bug.

As a workaround you can just create a "metric" visualization, and do a "top hit" for each of the values you're wanting to show.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/7/97a62f4133abf411bf92267dae37ae70788374a6.png)

---

<div class="post-metadata">

**Author:** ![arnim](https://avatars.discourse-cdn.com/v4/letter/a/4da419/32.png) [@arnim](https://discuss.elastic.co/u/arnim)\
**Post date:** [September 18, 2019, 2:58am UTC](https://discuss.elastic.co/t/displaying-string-text-value-in-tsvb/199223/3 "2019-09-18T02:58:34Z")

</div>

Thanks for your reply.

From what I understand and what I see from your screenshot above, .keyword fields should just output the string, right?  
Should I report this as a bug that TSVB is unable to display string keywords?

---

<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 16, 2019, 2:58am UTC](https://discuss.elastic.co/t/displaying-string-text-value-in-tsvb/199223/4 "2019-10-16T02:58:42Z")

</div>

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