# Increase Kibana data table bucket size

**URL:** <https://discuss.elastic.co/t/increase-kibana-data-table-bucket-size/291284>\
**Category:** Kibana\
**Created:** [December 9, 2021, 3:43am UTC](https://discuss.elastic.co/t/increase-kibana-data-table-bucket-size/291284 "2021-12-09T03:43:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![cps598](https://avatars.discourse-cdn.com/v4/letter/c/858c86/32.png) [@cps598](https://discuss.elastic.co/u/cps598)\
**Post date:** [December 9, 2021, 3:43am UTC](https://discuss.elastic.co/t/increase-kibana-data-table-bucket-size/291284/1 "2021-12-09T03:43:59Z")

</div>

Kibana v 7.15.1

I want to show some items in the Kibana data table. And I found that the size of the bucket restricts the showing results. For example, if I set the size to 20, some log data will not be displayed on the table.

I would like to ask if any methods to set the size automatically depending on the shown data's requirements.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/0/50d5e9c695ed886f11919c1055ff5ea20f7d8286.png)

Thank you!

---

<div class="post-metadata">

**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\
**Post date:** [December 9, 2021, 7:40am UTC](https://discuss.elastic.co/t/increase-kibana-data-table-bucket-size/291284/2 "2021-12-09T07:40:21Z")

</div>

Hey @cps598 the terms aggregation in kibana datatable defaults to size 5. In ES if you don't define a size, it returns the top 10 terms. If you need more values to be displayed you have to increase this size manually. This doesn't work automatically.  
The terms aggregation is mostly used to identify the top terms with the most documents.  
An important note here is that larger values of `size` use more memory to compute and, push the whole aggregation close to the `max_buckets` limit.  
You could also use the `Group other values` switch which actually groups all the remaining values into a separate bucket. In that way you can have the top 20 terms and all the others grouped in one bucket.

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

---

<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 6, 2022, 7:41am UTC](https://discuss.elastic.co/t/increase-kibana-data-table-bucket-size/291284/3 "2022-01-06T07:41:18Z")

</div>

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