# Kibana dont show all messages in datatable

**URL:** <https://discuss.elastic.co/t/kibana-dont-show-all-messages-in-datatable/159327>\
**Category:** Kibana\
**Created:** [December 4, 2018, 9:52am UTC](https://discuss.elastic.co/t/kibana-dont-show-all-messages-in-datatable/159327 "2018-12-04T09:52:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Oleg\_Gorelikov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/oleg_gorelikov/32/43680_2.png) [@Oleg\_Gorelikov](https://discuss.elastic.co/u/Oleg_Gorelikov)\
**Post date:** [December 4, 2018, 9:52am UTC](https://discuss.elastic.co/t/kibana-dont-show-all-messages-in-datatable/159327/1 "2018-12-04T09:52:18Z")

</div>

Hello!  
I created saved search, where i have messages with word "Ошибка". In this search i see all messages - its correct:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/6/8628d4cf6da531f6e850cb017abfc207674059d8.png)

Then i need to see agregation by sum of this message in visualization. When i created visualization i see not all messages in this agregation

![image](https://us1.discourse-cdn.com/elastic/original/3X/e/e/eea7091a5dce9ffbecc7171fecd14656f06e06cd.png)

Can anyone help me?

---

<div class="post-metadata">

**Author:** ![Oleg\_Gorelikov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/oleg_gorelikov/32/43680_2.png) [@Oleg\_Gorelikov](https://discuss.elastic.co/u/Oleg_Gorelikov)\
**Post date:** [December 4, 2018, 10:49am UTC](https://discuss.elastic.co/t/kibana-dont-show-all-messages-in-datatable/159327/2 "2018-12-04T10:49:47Z")

</div>

I found this messages. These strings having one value - "Missing". Why?

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/c/ac7e863c43f4b2b7fdd8f5aae6c806d1e91531a3.png)

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [December 12, 2018, 10:32pm UTC](https://discuss.elastic.co/t/kibana-dont-show-all-messages-in-datatable/159327/3 "2018-12-12T22:32:55Z")

</div>

Hi,

You have the missing values enabled on your aggregation which is visible in your visualization editor. So missing is displaying the count of documents without the message.keyword in the last 24 hours.

[https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-missing-aggregation.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-missing-aggregation.html)

You can also create a visualization using a saved search. Can you please try saving your search query in discover and creating a visualization based on it?

Thanks,  
Bhavya

---

<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:** [January 9, 2019, 10:32pm UTC](https://discuss.elastic.co/t/kibana-dont-show-all-messages-in-datatable/159327/4 "2019-01-09T22:32:57Z")

</div>

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