# Data table viz excludes records where bucket term is blank \[SOLVED\]

**URL:** https://discuss.elastic.co/t/data-table-viz-excludes-records-where-bucket-term-is-blank-solved/43804
**Category:** Kibana
**Created:** [March 8, 2016, 4:22pm UTC](https://discuss.elastic.co/t/data-table-viz-excludes-records-where-bucket-term-is-blank-solved/43804 "2016-03-08T16:22:54Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![ChrisR](https://avatars.discourse-cdn.com/v4/letter/c/ecd19e/32.png) [@ChrisR](https://discuss.elastic.co/u/ChrisR)
#### Post date: [March 8, 2016, 4:22pm UTC](https://discuss.elastic.co/t/data-table-viz-excludes-records-where-bucket-term-is-blank-solved/43804/1 "2016-03-08T16:22:54Z")

</div>

The data table is excluding rows where bucket term is blank.

For example, assume I have the following data:  
{"id":1, "item":"widget1", "type":"toy", "color":"blue", "price":5.05}  
{"id":2, "item":"widget2", "type":"toy", "color":"", "price":3.15}

If I create a data table, there will be a count of two.  
If I split the rows with buckets on the term "color", I get one row with a count of 1 for blue.

Shouldn't there also be a second row with a blank color and a count of 1?

I'm seeing this with Kibana 4.4.0, window 7 and IE 11.

---

<div class="post-metadata">

### Author: ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [March 9, 2016, 6:18am UTC](https://discuss.elastic.co/t/data-table-viz-excludes-records-where-bucket-term-is-blank-solved/43804/2 "2016-03-09T06:18:12Z")

</div>

You'd need support for "missing" in Kibana Terms agg treatment, which is not there at the moment: [https://github.com/elastic/kibana/issues/1961](https://github.com/elastic/kibana/issues/1961)

---

<div class="post-metadata">

### Author: ![ChrisR](https://avatars.discourse-cdn.com/v4/letter/c/ecd19e/32.png) [@ChrisR](https://discuss.elastic.co/u/ChrisR)
#### Post date: [March 9, 2016, 5:28pm UTC](https://discuss.elastic.co/t/data-table-viz-excludes-records-where-bucket-term-is-blank-solved/43804/3 "2016-03-09T17:28:28Z")

</div>

I see now that this can be done by selecting "Show partial rows" on the "Options" table of the data table visualization.

---

<div class="post-metadata">

### Author: ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [March 9, 2016, 6:38pm UTC](https://discuss.elastic.co/t/data-table-viz-excludes-records-where-bucket-term-is-blank-solved/43804/4 "2016-03-09T18:38:14Z")

</div>

What version are you using? That option makes no difference for me.

![](https://us1.discourse-cdn.com/elastic/original/2X/f/f437d4998757eb5188cd8b530be708ef77b0372b.png)

 ![](https://us1.discourse-cdn.com/elastic/original/2X/f/faa51647d1ce2394e2e75d357d2c78f3d80e3d82.png)

---

<div class="post-metadata">

### Author: ![ChrisR](https://avatars.discourse-cdn.com/v4/letter/c/ecd19e/32.png) [@ChrisR](https://discuss.elastic.co/u/ChrisR)
#### Post date: [March 9, 2016, 6:58pm UTC](https://discuss.elastic.co/t/data-table-viz-excludes-records-where-bucket-term-is-blank-solved/43804/5 "2016-03-09T18:58:34Z")

</div>

I'm using Kibana 4.4.0 and Elasticsearch 2.2.0.

In your case is the field present with an empty string value, or is the field missing altogether? In my case the field is present with an empty string, e.g., {"key":""}

---

<div class="post-metadata">

### Author: ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [March 12, 2016, 6:41am UTC](https://discuss.elastic.co/t/data-table-viz-excludes-records-where-bucket-term-is-blank-solved/43804/6 "2016-03-12T06:41:53Z")

</div>

Same here, odd. Maybe related to this: [https://github.com/elastic/kibana/issues/4765](https://github.com/elastic/kibana/issues/4765)

---

<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: [July 6, 2017, 1:59pm UTC](https://discuss.elastic.co/t/data-table-viz-excludes-records-where-bucket-term-is-blank-solved/43804/7 "2017-07-06T13:59:20Z")

</div>