Filter of kibana : extracting documents with a condition


(marwa) #1

Hi ,
i have data of transactions, each transaction is made by a customer ,
i want to extrat only documents where i have repeat customer (a customer that had made more then one transaction) so i have to filter the documents based on the occurrence of each customer hich have to be greater than one.Can i do this with the filter disposed in kibana with a query DSL because i need to use the results in kibana visualization.


(Lee Drengenberg) #2

Hi Marwa,

You can use the Advanced field in visualizations to set { "min_doc_count": 2} for your case. See the gif below. The data initially has values of 2, 1, 1, 5. But after I had the JSON Input those values are filtered out.

Regards,
Lee


(system) #3

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