# Kibana visualisation no results found in data table

**URL:** <https://discuss.elastic.co/t/kibana-visualisation-no-results-found-in-data-table/108637>\
**Category:** Kibana\
**Created:** [November 22, 2017, 4:57am UTC](https://discuss.elastic.co/t/kibana-visualisation-no-results-found-in-data-table/108637 "2017-11-22T04:57:11Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jonesthomas](https://avatars.discourse-cdn.com/v4/letter/j/f4b2a3/32.png) [@Jonesthomas](https://discuss.elastic.co/u/Jonesthomas)\
**Post date:** [November 22, 2017, 4:57am UTC](https://discuss.elastic.co/t/kibana-visualisation-no-results-found-in-data-table/108637/1 "2017-11-22T04:57:11Z")

</div>

i have this data in kibana discover, but in visualization `ErrorMsg` is showing no results found.

 ![Untitled1](https://us1.discourse-cdn.com/elastic/original/3X/6/3/633ad3a95f35551e75e12dab586b8b13a7a81524.png)  
 ![Untitled](https://us1.discourse-cdn.com/elastic/original/3X/3/5/35c7ea6e239fc34401fea66e51f663c701424684.png)

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [November 22, 2017, 7:59am UTC](https://discuss.elastic.co/t/kibana-visualisation-no-results-found-in-data-table/108637/2 "2017-11-22T07:59:14Z")

</div>

`@timestamp` is in UTC. Kibana by default adjusts for the time-zone you are in. If you are not in UTC timezone, the time picker therefore may need to be adjusted. Could this be the problem?

---

<div class="post-metadata">

**Author:** ![Jonesthomas](https://avatars.discourse-cdn.com/v4/letter/j/f4b2a3/32.png) [@Jonesthomas](https://discuss.elastic.co/u/Jonesthomas)\
**Post date:** [November 22, 2017, 8:17am UTC](https://discuss.elastic.co/t/kibana-visualisation-no-results-found-in-data-table/108637/3 "2017-11-22T08:17:38Z")

</div>

no , only the field is not showing in visualization .😐

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [November 22, 2017, 8:33am UTC](https://discuss.elastic.co/t/kibana-visualisation-no-results-found-in-data-table/108637/4 "2017-11-22T08:33:32Z")

</div>

So if you remove the last aggregation level you see data?

---

<div class="post-metadata">

**Author:** ![Jonesthomas](https://avatars.discourse-cdn.com/v4/letter/j/f4b2a3/32.png) [@Jonesthomas](https://discuss.elastic.co/u/Jonesthomas)\
**Post date:** [November 22, 2017, 8:42am UTC](https://discuss.elastic.co/t/kibana-visualisation-no-results-found-in-data-table/108637/5 "2017-11-22T08:42:03Z")

</div>

yes i see data after removing the last aggregation..

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [November 22, 2017, 9:12am UTC](https://discuss.elastic.co/t/kibana-visualisation-no-results-found-in-data-table/108637/6 "2017-11-22T09:12:26Z")

</div>

Can you show us what that looks like? You also have a little button at the bottom of the visualisation that will allow you to inspect the response. Can you please share that as well when you have the last level in place?

---

<div class="post-metadata">

**Author:** ![Jonesthomas](https://avatars.discourse-cdn.com/v4/letter/j/f4b2a3/32.png) [@Jonesthomas](https://discuss.elastic.co/u/Jonesthomas)\
**Post date:** [November 22, 2017, 10:17am UTC](https://discuss.elastic.co/t/kibana-visualisation-no-results-found-in-data-table/108637/7 "2017-11-22T10:17:13Z")

</div>

`{ "took": 10, "timed_out": false, "_shards": { "total": 40, "successful": 40, "failed": 0 }, "hits": { "total": 43, "max_score": 0, "hits": [] }, "aggregations": { "2": { "buckets": { "appserver": { "8": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] }, "doc_count": 8 } } } }, "status": 200 }`

---

<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 20, 2017, 10:17am UTC](https://discuss.elastic.co/t/kibana-visualisation-no-results-found-in-data-table/108637/8 "2017-12-20T10:17:28Z")

</div>

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