Filter out all docs that occur more than once

6tUBp3gwd9Zp · March 3, 2020, 10:10am

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)

rashmi · March 19, 2020, 5:08pm

Hello,

You can try unique count splitting on the field you wish to see the unique values for.

`

You can add sub buckets for additional columns.
Hope this helps,
Thanks
Rashmi

system · April 16, 2020, 5:08pm

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
{"min_doc_count"} on Unique Count aggregation Kibana	2	3150	May 1, 2019
Filter results on "Unique Count" aggregation Kibana	4	1206	March 5, 2020
Create a Table that shows only docs where the unique count of a specific field is difference of 2 Kibana	7	1869	May 8, 2017
Filtering table entries Kibana	1	251	January 2, 2020
How can I filter by count? / How can I apply a custom filter? Kibana	5	1283	July 6, 2017

Filter out all docs that occur more than once

Related topics