# Filtering the data list from Discover to only see Unique Ids
**URL:** https://discuss.elastic.co/t/filtering-the-data-list-from-discover-to-only-see-unique-ids/280472
**Category:** Kibana
**Tags:** docker
**Created:** [August 4, 2021, 7:36pm UTC](https://discuss.elastic.co/t/filtering-the-data-list-from-discover-to-only-see-unique-ids/280472 "2021-08-04T19:36:56Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@bailarch](https://discuss.elastic.co/u/bailarch)
#### Post date: [August 4, 2021, 7:36pm UTC](https://discuss.elastic.co/t/filtering-the-data-list-from-discover-to-only-see-unique-ids/280472/1 "2021-08-04T19:36:56Z")
Hello guys - not sure if the subcategory for this issue is docker (not sure what this is but the other options seem incorrect for me)
I am trying to get the list of all the users name from Discovery.
However I am seeing multiple / duplicate values but there is no 'filter out duplicate' from filter function. I was trying to google or try different ways to have only unique ids or get rid of all the duplicate values but no good.
Can anyone help me how to filter unique IDs only for discover or dashboard data list? Thank you.
---
### Author:  [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)
#### Post date: [August 4, 2021, 9:34pm UTC](https://discuss.elastic.co/t/filtering-the-data-list-from-discover-to-only-see-unique-ids/280472/2 "2021-08-04T21:34:02Z")
Hello,
So you cannot do it in discover. But can you please try lens?
> **[Kibana Lens](https://www.elastic.co/kibana/kibana-lens)**
>
> Bring instant clarity to your data with the Kibana Lens UI. Drag and drop Elasticsearch field types for easy data visualization — no prior Kibana experience required.
The data table in it might give you exactly what you need.
Thanks
Bhavya
---
### Author:  [@bailarch](https://discuss.elastic.co/u/bailarch)
#### Post date: [August 5, 2021, 2:18pm UTC](https://discuss.elastic.co/t/filtering-the-data-list-from-discover-to-only-see-unique-ids/280472/3 "2021-08-05T14:18:41Z")
Hello,
Thank you for the response. The reason why I moved on to Discover is because Dashboard only shoes you 100 values max and the rest go into 'Other' - Please see the image below.
Is there a way where we can 'explode' or expand out those values from others?
Thank you very much
---
### Author:  [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)
#### Post date: [August 5, 2021, 2:22pm UTC](https://discuss.elastic.co/t/filtering-the-data-list-from-discover-to-only-see-unique-ids/280472/4 "2021-08-05T14:22:39Z")
Hi,
When the rest go into "other" that means some documents in your database don't have field value for user.name. Kibana is displaying that correctly.
You can check for it by making a filter on other and go to discover and inspect those documents.
Thanks
Bhavya
---
### Author:  [@bailarch](https://discuss.elastic.co/u/bailarch)
#### Post date: [August 5, 2021, 2:38pm UTC](https://discuss.elastic.co/t/filtering-the-data-list-from-discover-to-only-see-unique-ids/280472/5 "2021-08-05T14:38:12Z")
Thank you for the response
However the amount of values that I can see from Dashboard - Lens is max 100 though right?
Thats the max value that I can put in from the setting page.
---
### Author:  [@ghudgins](https://discuss.elastic.co/u/ghudgins)
#### Post date: [August 5, 2021, 4:12pm UTC](https://discuss.elastic.co/t/filtering-the-data-list-from-discover-to-only-see-unique-ids/280472/6 "2021-08-05T16:12:22Z")
The lens 100 limit was increased to 1000 in 7.13 I believe
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [August 6, 2021, 2:33am UTC](https://discuss.elastic.co/t/filtering-the-data-list-from-discover-to-only-see-unique-ids/280472/7 "2021-08-06T02:33:51Z")
Slight correction for clarity
Kibana is displaying correctly
However `other` is the sum of all other documents with user `user.name` values that are not included in the Top N
If `user.name` field does not have a value it is not included in the table / aggregation.
Lens will work the same way.
---
### Author:  [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)
#### Post date: [August 9, 2021, 3:21pm UTC](https://discuss.elastic.co/t/filtering-the-data-list-from-discover-to-only-see-unique-ids/280472/8 "2021-08-09T15:21:49Z")
Thanks @stephenb I confused the other bucket with missing in traditional xy vizs 🙂
Your answer clarifies it.
---
### Author:  [@bailarch](https://discuss.elastic.co/u/bailarch)
#### Post date: [August 10, 2021, 3:44pm UTC](https://discuss.elastic.co/t/filtering-the-data-list-from-discover-to-only-see-unique-ids/280472/9 "2021-08-10T15:44:42Z")
hello Thank you for the response but my lens limit is still set to 100. Is there a way where we can update the version?
---
### Author:  [@rcowart](https://discuss.elastic.co/u/rcowart)
#### Post date: [August 12, 2021, 6:45am UTC](https://discuss.elastic.co/t/filtering-the-data-list-from-discover-to-only-see-unique-ids/280472/10 "2021-08-12T06:45:19Z")
@bailarch In my opinion Lens is probably the worst of all of the Kibana visualization options, and the wrong choice for what you want. I recommend using the plain data table visualization. You can set the size of the result set in a bucket to whatever number you need. In this case I set it to 50000 and I am displaying 20 rows per page. You see that I have 1347 pages of results in my data.
---
### Author:  [@bailarch](https://discuss.elastic.co/u/bailarch)
#### Post date: [August 12, 2021, 1:10pm UTC](https://discuss.elastic.co/t/filtering-the-data-list-from-discover-to-only-see-unique-ids/280472/11 "2021-08-12T13:10:25Z")
Hi !
Thank you for the response - I thought the same and realized Visualization option is better. However my concern is I don't know how to create one. I've been looking into the templates that Elastic Cloud create but wasn't able to make my own. Do you perhaps know where I could find the guideline to make data table visualization?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 9, 2021, 1:10pm UTC](https://discuss.elastic.co/t/filtering-the-data-list-from-discover-to-only-see-unique-ids/280472/12 "2021-09-09T13:10:53Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.