# Filter out all docs that occur more than once **URL:** \ **Category:** Kibana\ **Created:** [March 3, 2020, 10:10am UTC](https://discuss.elastic.co/t/filter-out-all-docs-that-occur-more-than-once/221848 "2020-03-03T10:10:07Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![6tUBp3gwd9Zp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/6tubp3gwd9zp/32/45240_2.png) [@6tUBp3gwd9Zp](https://discuss.elastic.co/u/6tUBp3gwd9Zp)\ **Post date:** [March 3, 2020, 10:10am UTC](https://discuss.elastic.co/t/filter-out-all-docs-that-occur-more-than-once/221848/1 "2020-03-03T10:10:07Z")
Hello, I want to filter out all entries from a table that have a count greater than 1. (red ones in the picture) Since I don't want to see them at all the "TopHit" aggregation isn't helpful. How can I achieve this otherwise? (Kibana Version is 6.8.1) ![-](https://us1.discourse-cdn.com/elastic/original/3X/7/a/7a122d6d4c428011d755df99f8c819f3e02c7161.png) ---
**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\ **Post date:** [March 19, 2020, 5:08pm UTC](https://discuss.elastic.co/t/filter-out-all-docs-that-occur-more-than-once/221848/2 "2020-03-19T17:08:33Z")
Hello, You can try `unique count splitting on the field you wish to see the unique values for.` ![Screen Shot 2020-03-19 at 10.02.44 AM](https://us1.discourse-cdn.com/elastic/original/3X/3/3/338263d45a71f24b334ba197ff7b51a90672e2c1.png) ` You can add sub buckets for additional columns. Hope this helps, Thanks Rashmi ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 16, 2020, 5:08pm UTC](https://discuss.elastic.co/t/filter-out-all-docs-that-occur-more-than-once/221848/3 "2020-04-16T17:08:33Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.