# Data Table shows No results found, I guess because of unique entries

**URL:** <https://discuss.elastic.co/t/data-table-shows-no-results-found-i-guess-because-of-unique-entries/155175>\
**Category:** Kibana\
**Created:** [November 2, 2018, 1:37pm UTC](https://discuss.elastic.co/t/data-table-shows-no-results-found-i-guess-because-of-unique-entries/155175 "2018-11-02T13:37:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![humalog](https://avatars.discourse-cdn.com/v4/letter/h/cc9497/32.png) [@humalog](https://discuss.elastic.co/u/humalog)\
**Post date:** [November 2, 2018, 1:37pm UTC](https://discuss.elastic.co/t/data-table-shows-no-results-found-i-guess-because-of-unique-entries/155175/1 "2018-11-02T13:37:14Z")

</div>

Hi folks,  
i try to visualize a Data Table. I have a XML File which i indexed. I have following issue:  
I am not able to get the text of an element of the XML file into the Data Table, because there is a blank line before the XML element closes.

Here is a sample of my XML

```auto
<plugin_output>
Ubuntu 12.04 support ended on 2017-04-30.
Ubgrade to Ubuntu 17.10.

For more information, see: https://wiki.ubuntu.com/Releases

</plugin_output>

```

I just get a data table without plugin\_output, if i press "Show missing values".

Following text are shown in the Data Table, when there isn't a blank line at the end:

```auto
<plugin_output>
The following issues were reported :

  - Plugin : no_local_checks_credentials.nasl
    Plugin ID : 110723
    Plugin Name : No Credentials Provided
    Message : 
Credentials were not provided for detected SSH service.
</plugin_output>

```

Is there any option I can use without editing my whole XML file?

Best regards

---

<div class="post-metadata">

**Author:** ![humalog](https://avatars.discourse-cdn.com/v4/letter/h/cc9497/32.png) [@humalog](https://discuss.elastic.co/u/humalog)\
**Post date:** [November 2, 2018, 1:50pm UTC](https://discuss.elastic.co/t/data-table-shows-no-results-found-i-guess-because-of-unique-entries/155175/2 "2018-11-02T13:50:59Z")

</div>

I think my problem is something else. I have to play around with visualization a bit more...

I think the problem is because of the Count Metric.  
I have unique entries there. Is it possible to show this unique entries in Data Table Visualization?

---

<div class="post-metadata">

**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\
**Post date:** [November 2, 2018, 2:33pm UTC](https://discuss.elastic.co/t/data-table-shows-no-results-found-i-guess-because-of-unique-entries/155175/3 "2018-11-02T14:33:03Z")

</div>

Hi,  
you can add the field in as a bucket and you'll see all of its values in the table or you can simply go back to your discover tab and see the value there.  
To filter your table for that value, add a bucket (or sub-bucket) as 'split rows', in 'sub aggregation' select 'filter' and on the filter space write your restriction, for example, age=20 if you only want lines where the age field is 20.

hope this helps,  
Rashmi

---

<div class="post-metadata">

**Author:** ![humalog](https://avatars.discourse-cdn.com/v4/letter/h/cc9497/32.png) [@humalog](https://discuss.elastic.co/u/humalog)\
**Post date:** [November 5, 2018, 9:54am UTC](https://discuss.elastic.co/t/data-table-shows-no-results-found-i-guess-because-of-unique-entries/155175/4 "2018-11-05T09:54:54Z")

</div>

Hi,  
I work with sub-buckets to extract the Plugin Output. I used the "Advanced" option to filter my output. I have 5 different 'risk\_Factor' (None, Low, Medium, High, Critical). I get 'plugin\_output' for just 4 of 5 'risk\_factors' (None - Medium) but when i filter Critical, i get no plugin\_output and I don't understand why.

Anyway, thanks for your help

---

<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:** [December 3, 2018, 9:55am UTC](https://discuss.elastic.co/t/data-table-shows-no-results-found-i-guess-because-of-unique-entries/155175/5 "2018-12-03T09:55:06Z")

</div>

Closed on December 3, 2018, 9:55am UTC

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