# Limit the number of pages on kibana datatable visualization **URL:** \ **Category:** Kibana\ **Created:** [September 23, 2021, 8:53pm UTC](https://discuss.elastic.co/t/limit-the-number-of-pages-on-kibana-datatable-visualization/285031 "2021-09-23T20:53:41Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Srikanth\_V](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/srikanth_v/32/86839_2.png) [@Srikanth\_V](https://discuss.elastic.co/u/Srikanth_V)\ **Post date:** [September 23, 2021, 8:53pm UTC](https://discuss.elastic.co/t/limit-the-number-of-pages-on-kibana-datatable-visualization/285031/1 "2021-09-23T20:53:41Z")
Hello people, I'm currently using the kibana dashboard and showing them in my application using iframe. Currently the data table has 100 pages with 10 rows being displayed on each page. Is there is a way to limit the number of pages to 20 instead of showing all 100 pages ? Any help would be appreciated. Thanks ---
**Author:** ![Srikanth\_V](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/srikanth_v/32/86839_2.png) [@Srikanth\_V](https://discuss.elastic.co/u/Srikanth_V)\ **Post date:** [September 24, 2021, 10:06am UTC](https://discuss.elastic.co/t/limit-the-number-of-pages-on-kibana-datatable-visualization/285031/2 "2021-09-24T10:06:14Z")
It is a bit urgent and any help on this would be really really helpful. ---
**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\ **Post date:** [September 24, 2021, 7:57pm UTC](https://discuss.elastic.co/t/limit-the-number-of-pages-on-kibana-datatable-visualization/285031/3 "2021-09-24T19:57:50Z")
If you're doing something like a terms aggregation to split rows, there's a size parameter; ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/e/aef69cc103c4ad08c44901b19e8dd44326c1b142.png) If that doesn't work, we may need more details on how your data table is configured. ---
**Author:** ![Srikanth\_V](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/srikanth_v/32/86839_2.png) [@Srikanth\_V](https://discuss.elastic.co/u/Srikanth_V)\ **Post date:** [September 24, 2021, 8:01pm UTC](https://discuss.elastic.co/t/limit-the-number-of-pages-on-kibana-datatable-visualization/285031/4 "2021-09-24T20:01:33Z")
Thanks for your reply. I'm using the size property for my split rows with size 1000, so after applying all my filters, the number of pages show up as 53 pages, but I want to show only 10 pages and not show the rest of the 43 pages. For example ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/2/42e960ffa8da73b4c4ec4ce11dc9136557915e27.png) I hope I'm clear now ---
**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\ **Post date:** [September 24, 2021, 9:40pm UTC](https://discuss.elastic.co/t/limit-the-number-of-pages-on-kibana-datatable-visualization/285031/5 "2021-09-24T21:40:41Z")
Seems like if you set the size to 100 instead of 1000 then you will have 10 pages of 10 rows. ---
**Author:** ![Srikanth\_V](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/srikanth_v/32/86839_2.png) [@Srikanth\_V](https://discuss.elastic.co/u/Srikanth_V)\ **Post date:** [September 24, 2021, 9:51pm UTC](https://discuss.elastic.co/t/limit-the-number-of-pages-on-kibana-datatable-visualization/285031/6 "2021-09-24T21:51:44Z")
But once I apply the filter on top of it, won't the number of pages reduce because the total results will also reduce right ? Also I would want to search on the 101th element as well, but I initially would want to show only 10 pages. I know it's a bit tricky and the expectation is a bit weird as well ---
**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\ **Post date:** [September 24, 2021, 10:58pm UTC](https://discuss.elastic.co/t/limit-the-number-of-pages-on-kibana-datatable-visualization/285031/7 "2021-09-24T22:58:18Z")
The size restriction is applied to the filtered results. Not the other way around. So if you add a filter to the visualization or a dashboard containing this data table, you will get up to the 100 top scoring results which match the filter. ---
**Author:** ![Srikanth\_V](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/srikanth_v/32/86839_2.png) [@Srikanth\_V](https://discuss.elastic.co/u/Srikanth_V)\ **Post date:** [September 29, 2021, 10:11am UTC](https://discuss.elastic.co/t/limit-the-number-of-pages-on-kibana-datatable-visualization/285031/8 "2021-09-29T10:11:49Z")
Thanks @LeeDr for your help. I guess for now I can live with this solution. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [October 27, 2021, 10:11am UTC](https://discuss.elastic.co/t/limit-the-number-of-pages-on-kibana-datatable-visualization/285031/9 "2021-10-27T10:11:57Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.