# Data Table creation with Filters
**URL:** https://discuss.elastic.co/t/data-table-creation-with-filters/212570
**Category:** Kibana
**Created:** [December 19, 2019, 10:02pm UTC](https://discuss.elastic.co/t/data-table-creation-with-filters/212570 "2019-12-19T22:02:30Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Shyamcharan](https://discuss.elastic.co/u/Shyamcharan)
#### Post date: [December 19, 2019, 10:02pm UTC](https://discuss.elastic.co/t/data-table-creation-with-filters/212570/1 "2019-12-19T22:02:31Z")
Hi,
I am new user in Kibana. I wanted to create a data-table with almost 7 or 8 columns and 5000+ rows of data. I need to apply few filters as well on that data. Is it possible to create this kind of visualization in kibana like how we can populate in excel?
When I try to apply filters , the data that populating is not accurate. Suggest me way to create a big data table with filters.
Thanks,
Shyam
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [December 20, 2019, 1:12pm UTC](https://discuss.elastic.co/t/data-table-creation-with-filters/212570/2 "2019-12-20T13:12:56Z")
The data table is not fit for large number of rows like you want. It's meant for aggregated data.
The closest thing to what you want is the Discover page where you can add fields from the left panel as columns in the discover page and basically make a table. And filters go in the search bar at the top.
---
### Author:  [@Shyamcharan](https://discuss.elastic.co/u/Shyamcharan)
#### Post date: [December 20, 2019, 2:35pm UTC](https://discuss.elastic.co/t/data-table-creation-with-filters/212570/3 "2019-12-20T14:35:22Z")
Hi Marius,
Thanks for the reply. There are duplicate values in a field and I want to perform unique count on that. If i do on discover , How can i do the unique count?
Thanks,
Shyam
---
### Author:  [@Shyamcharan](https://discuss.elastic.co/u/Shyamcharan)
#### Post date: [December 20, 2019, 2:41pm UTC](https://discuss.elastic.co/t/data-table-creation-with-filters/212570/4 "2019-12-20T14:41:59Z")
Can i add unique count or cardinality in the query statement which i can add in search bar?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 17, 2020, 2:42pm UTC](https://discuss.elastic.co/t/data-table-creation-with-filters/212570/5 "2020-01-17T14:42:04Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [January 28, 2020, 11:50am UTC](https://discuss.elastic.co/t/data-table-creation-with-filters/212570/6 "2020-01-28T11:50:23Z")
You can add a saved search on the dashboard to show the data table and all the fields and a visualization, like a metric that shows the unique count next to it.