# Visualize in Data Table
**URL:** https://discuss.elastic.co/t/visualize-in-data-table/55792
**Category:** Kibana
**Created:** [July 18, 2016, 6:23pm UTC](https://discuss.elastic.co/t/visualize-in-data-table/55792 "2016-07-18T18:23:34Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@piyush](https://discuss.elastic.co/u/piyush)
#### Post date: [July 18, 2016, 6:23pm UTC](https://discuss.elastic.co/t/visualize-in-data-table/55792/1 "2016-07-18T18:23:34Z")
Hi Team,
I am trying to build an informative Data table that includes fields, arrays and objects, they are "not analyzed" for better aggregation. But when i am adding few fields, query is not returning any result and it displays "No results found".
I am using "count" as metric, didn't find anything suitable. Although, my objective is to prepare data table, i don't really need any of the metric values.
I guess the reason is, some of the fields are empty or even doesn't exists in some cases. My question is, how can we allow null values and null columns in the Data table?
Thanks & Regards
---
### Author:  [@shaunak](https://discuss.elastic.co/u/shaunak)
#### Post date: [July 18, 2016, 7:59pm UTC](https://discuss.elastic.co/t/visualize-in-data-table/55792/2 "2016-07-18T19:59:19Z")
Hi @piyush,
Can you share the query request that Kibana is making to Elasticsearch and the response from it?
The easiest way to find the request and response would be to open the spy panel for the data table visualization you are building. To do this, click on the little `^` under the data table visualization, then click on "Request" and "Response" to see the request and response respectively. If you could paste the request and response into this post, that would help figure out what's going on.
Thanks!
Shaunak
---
### Author:  [@piyush](https://discuss.elastic.co/u/piyush)
#### Post date: [July 18, 2016, 10:44pm UTC](https://discuss.elastic.co/t/visualize-in-data-table/55792/3 "2016-07-18T22:44:07Z")
Hi Shaunak,
I am not getting request/response when "no result found".
But i notice that it's a date field (create date but data type is string) for which i am getting error.
1. if create\_date is first field i am getting result.
2. but if i add second field instance\_id then it says "no result found"
( create\_date and instance\_id both are string)
Thanks & Regards
---
### Author:  [@shaunak](https://discuss.elastic.co/u/shaunak)
#### Post date: [July 18, 2016, 10:58pm UTC](https://discuss.elastic.co/t/visualize-in-data-table/55792/4 "2016-07-18T22:58:20Z")
Can you share screenshots of your Visualize page showing both scenarios, 1 and 2? It might make it easier for me to understand what is going on.
---
### Author:  [@piyush](https://discuss.elastic.co/u/piyush)
#### Post date: [July 18, 2016, 11:39pm UTC](https://discuss.elastic.co/t/visualize-in-data-table/55792/5 "2016-07-18T23:39:36Z")
Hi Shunak,
Before taking snapshot i tried one thing and not sure how but when i refresh index and rebuild data table (@timestamp first field, data type timestamp) it's populating desire output.
I still have one question, how can we consider "Null" values? count metric will never allow a result if any of the field is blank.
Thanks & Regards
---
### Author:  [@shaunak](https://discuss.elastic.co/u/shaunak)
#### Post date: [July 19, 2016, 12:27am UTC](https://discuss.elastic.co/t/visualize-in-data-table/55792/6 "2016-07-19T00:27:14Z")
To include counts of null or missing values, add a snippet like the example shown below to the JSON input box in the "Advanced" section of the aggregation:
`{ "missing": "2016-07-03" }`
This will count all null/missing values and associate them with the "2016-07-03" bucket. Obviously change that bucket to whatever makes sense for your data.
---
### Author:  [@piyush](https://discuss.elastic.co/u/piyush)
#### Post date: [July 19, 2016, 9:30pm UTC](https://discuss.elastic.co/t/visualize-in-data-table/55792/7 "2016-07-19T21:30:15Z")
Thanks Shaunak, it helped.
Thanks & Regards
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:45pm UTC](https://discuss.elastic.co/t/visualize-in-data-table/55792/8 "2017-07-06T13:45:44Z")