# Kibana Data Table Pagination
**URL:** https://discuss.elastic.co/t/kibana-data-table-pagination/270819
**Category:** Kibana
**Created:** [April 21, 2021, 9:56am UTC](https://discuss.elastic.co/t/kibana-data-table-pagination/270819 "2021-04-21T09:56:53Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Noobmaster](https://discuss.elastic.co/u/Noobmaster)
#### Post date: [April 21, 2021, 9:56am UTC](https://discuss.elastic.co/t/kibana-data-table-pagination/270819/1 "2021-04-21T09:56:53Z")
Hi there,
I am new to elk and kibana. I have created this data table using 'kibana sample ecommerce data' by going through these steps 1. Dashboards-\> 2.Create Panel-\>3.Aggregation based-\>4. Data Tables. And I dragged few columns into the data table by keeping aggregation as unique count. **For the last 24 hours, it shows 134 records in single page and I want to be shown in 2-3 pages. So, please help me in acheiving this?**
 
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [April 21, 2021, 11:30am UTC](https://discuss.elastic.co/t/kibana-data-table-pagination/270819/2 "2021-04-21T11:30:52Z")
Lens is currently not able to do this, there is an open feature request for this: [[Lens] Table pagination · Issue #96778 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/96778)
However, the aggregation based data table does support this feature. You have to switch from "Data" to "Options" in the top right:
---
### Author:  [@Noobmaster](https://discuss.elastic.co/u/Noobmaster)
#### Post date: [April 21, 2021, 11:45am UTC](https://discuss.elastic.co/t/kibana-data-table-pagination/270819/3 "2021-04-21T11:45:46Z")
Hi there,
Thanks for your reply. So, if we need pagination we should use aggregation based datatable rather than going through lens-\>datatable correct?
And how can one add columns in the new data table. Previously there, It was simple drag and drop kind of thing.
Thanks for your time
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [April 21, 2021, 11:51am UTC](https://discuss.elastic.co/t/kibana-data-table-pagination/270819/4 "2021-04-21T11:51:05Z")
> Thanks for your reply. So, if we need pagination we should use aggregation based datatable rather than going through lens-\>datatable correct?
That's correct.
> And how can one add columns in the new data table. Previously there, It was simple drag and drop kind of thing.
You need to add buckets (for splitting up rows) and metrics (for showing aggregated metric columns).
For the table in your screenshot you need a "split rows" bucket using a terms aggregation for the gender, category and customer first name columns and a count metric for the count of records column.
---
### Author:  [@Noobmaster](https://discuss.elastic.co/u/Noobmaster)
#### Post date: [April 21, 2021, 12:00pm UTC](https://discuss.elastic.co/t/kibana-data-table-pagination/270819/5 "2021-04-21T12:00:19Z")
Thanks for your help. Yes , I was able to do it.
Sorry to bother you again, please share some link for beginners in kibana.
And also is server side pagination available in Kibana.
And the pagination in kibana. is it like lazy loading?
Once again, Thanks for your time.
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [April 21, 2021, 12:47pm UTC](https://discuss.elastic.co/t/kibana-data-table-pagination/270819/6 "2021-04-21T12:47:28Z")
Our official guide should give a good intro into everything: [Kibana Guide [8.11] | Elastic](https://www.elastic.co/guide/en/kibana/current/index.html)
> And also is server side pagination available in Kibana.
> And the pagination in kibana. is it like lazy loading?
We are not doing server side pagination at the moment, the aggregated data table pagination is purely client side for UX reasons.
---
### Author:  [@Noobmaster](https://discuss.elastic.co/u/Noobmaster)
#### Post date: [April 22, 2021, 4:50am UTC](https://discuss.elastic.co/t/kibana-data-table-pagination/270819/7 "2021-04-22T04:50:23Z")
Thanks for the information.
I have one last query.
Does triggering UI Actions/Buttons like edit,add and delete are available for kibana(Datatable etc.)?
Ex: I want to have a UI button/pop - up when accessed/clicked it should show options for editing a row in datatable or deleting the row etc?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 20, 2021, 4:51am UTC](https://discuss.elastic.co/t/kibana-data-table-pagination/270819/8 "2021-05-20T04:51:01Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.