Filter out all docs that occur more than once

[6tUBp3gwd9Zp]

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 (kulkarni)]

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