# Why Kibana "Visualize" does not show all records?

**URL:** <https://discuss.elastic.co/t/why-kibana-visualize-does-not-show-all-records/133296>\
**Category:** Kibana\
**Created:** [May 25, 2018, 9:25am UTC](https://discuss.elastic.co/t/why-kibana-visualize-does-not-show-all-records/133296 "2018-05-25T09:25:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![dr01](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dr01/32/8482_2.png) [@dr01](https://discuss.elastic.co/u/dr01)\
**Post date:** [May 25, 2018, 9:25am UTC](https://discuss.elastic.co/t/why-kibana-visualize-does-not-show-all-records/133296/1 "2018-05-25T09:25:03Z")

</div>

Our ELK stack is storing database slow queries. From "Visualize" for the last 24 hours it shows only 424 total entries:

 ![Capture](https://us1.discourse-cdn.com/elastic/original/3X/d/9/d9df21ef77638f735402f08e62a738fc04f37cd7.PNG)

However, from "Discover" the entries in the same lapse of time are much more; for instance, there are 1243 counts only for the last hour, and 989 for the previous hour.  
For the last 24 hours, Kibana "Discover" shows ~5700 records. Where are the ~5300 records missing in "Visualize"?

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [May 25, 2018, 2:28pm UTC](https://discuss.elastic.co/t/why-kibana-visualize-does-not-show-all-records/133296/2 "2018-05-25T14:28:10Z")

</div>

How is your `Split Rows` aggregation configured? One the discover tab, do you see `pattern.keyword` values that are not displayed in the visualize table?

---

<div class="post-metadata">

**Author:** ![dr01](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dr01/32/8482_2.png) [@dr01](https://discuss.elastic.co/u/dr01)\
**Post date:** [May 25, 2018, 3:06pm UTC](https://discuss.elastic.co/t/why-kibana-visualize-does-not-show-all-records/133296/3 "2018-05-25T15:06:40Z")

</div>

Split Rows Aggregation is done by Terms.

Yes, in Discover there are patterns that are not present in Visualize.

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [May 25, 2018, 3:45pm UTC](https://discuss.elastic.co/t/why-kibana-visualize-does-not-show-all-records/133296/4 "2018-05-25T15:45:28Z")

</div>

What value are you providing for `size` under `terms` aggregation?

---

<div class="post-metadata">

**Author:** ![dr01](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dr01/32/8482_2.png) [@dr01](https://discuss.elastic.co/u/dr01)\
**Post date:** [May 25, 2018, 3:52pm UTC](https://discuss.elastic.co/t/why-kibana-visualize-does-not-show-all-records/133296/5 "2018-05-25T15:52:25Z")

</div>

It's currently 8, but I've tried higher values and nothing changes (see the empty line at the bottom in the screenshot).

---

<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:** [June 22, 2018, 3:52pm UTC](https://discuss.elastic.co/t/why-kibana-visualize-does-not-show-all-records/133296/6 "2018-06-22T15:52:34Z")

</div>

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