Kibana Discovery tab - distinct / unique the results

[elad888 (elad)]

Hi
I would need to distinct my discovery results by customer ID,
and get all details of each customer latest action/document.
I am aware that i can get the unique count by using a visualization , BUT it is not enough , I need to get the full document details and there are many different customers : ) .
Please let me know if there is a way to do what i need
Thanks

BTW
My question is similar to the following discussion that was closed before replying completely :

Search data in discover tab, then apply unique count to results

I have a saved search in the discover tab that looks like this [image] I am wanting to sort this data based on the unique count of the username field. In this case, because all of the ip's in the data are the same, I want only one record to show. If there were two ip's in that data, I would want only two records to show. Is there a way to build a table this way? I have tried the data table in the visualization tab, and it does allow me to apply a metric that sorts the unique count of the user…

[weltenwort (Felix Stürmer)]

Hi @elad888,

unfortunately the discover app can not perform that transformation, but the "Data Table" visualization can achieve something similar. Just use a "Terms" aggregation on the field identifying your customers (e.g. customer_id) to generate the buckets and "Top Hit" aggregations as the metrics (e.g. on the _source field).

[elad888 (elad)]

@elad888

ould need to distinct my discovery results by customer ID,

Thanks Felix !!