# Data table visualizations and empty fields
**URL:** https://discuss.elastic.co/t/data-table-visualizations-and-empty-fields/28726
**Category:** Kibana
**Created:** [September 5, 2015, 10:10pm UTC](https://discuss.elastic.co/t/data-table-visualizations-and-empty-fields/28726 "2015-09-05T22:10:51Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@LansK](https://discuss.elastic.co/u/LansK)
#### Post date: [September 5, 2015, 10:10pm UTC](https://discuss.elastic.co/t/data-table-visualizations-and-empty-fields/28726/1 "2015-09-05T22:10:51Z")
In a data table visualization, I have a field that I use the metric count aggregation on. However, often the field is empty in many documents. When I try to use a bucket to split rows by terms in this field (to see the top counted terms), an empty result does not show up. (The field does exist in the document even when it is empty, and an empty is meaningful to me.) How can I make empty fields also show up in a count?
Or maybe there is a better way to do this (under the assumption that I cannot adjust documents with empty fields to be non-empty)?
---
### Author:  [@Pieter\_Agenbag](https://discuss.elastic.co/u/Pieter_Agenbag)
#### Post date: [September 9, 2015, 10:01am UTC](https://discuss.elastic.co/t/data-table-visualizations-and-empty-fields/28726/2 "2015-09-09T10:01:57Z")
Is it an analysed field ? Analysing nothing , yields no terms , so you cant really aggregate on nothing ... however if you're not interested in analysed terms - but the entire field , then you can use a not\_analysed mapping on the field (or a .raw version of it) ... using this field in your datatable should display the empty values as well as its an actual blank value.
---
### Author:  [@LansK](https://discuss.elastic.co/u/LansK)
#### Post date: [September 27, 2015, 6:42am UTC](https://discuss.elastic.co/t/data-table-visualizations-and-empty-fields/28726/3 "2015-09-27T06:42:03Z")
That is what I ended up doing. Thank you.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 2:12pm UTC](https://discuss.elastic.co/t/data-table-visualizations-and-empty-fields/28726/4 "2017-07-06T14:12:20Z")