I have a data set with among others the following fields:
Price and all sales are entered into Kibana as a single document.
Since my user group is a group of non coding users, I've created a dashboard and want to enable the users to find Customers that has purchased a combination of products. E.g. I want the user to be able to select Product A AND Product B AND Product C and see which customer that has purchased ALL of these products.
When I write
Product_name : (Product A AND Product B) in the Filter bar I get no results. However if I write the filter as
Product_name : Product A OR Product B I get the result of all customers that has EITHER bought Product A OR Product B but I'm only interested in the ones that has bought them BOTH.
Is there anyway to search for multiple results from a single field in the Kibana UI and writing a query to get the result?