The title of the post may not be very clear about what I am trying to achieve and there may be at least another post on the same request (but I could not find it).
On short, I have a situation where we need to create a facet on a Multi-select field on the product.
The Multi-select field allows (as the name says) the selection of multiple options for the same field.
The facet, however, will list all individual options for that field.
For example, the field could have the following options: Metal, Plastic, Glass.
Product One has Metal selected. Product 2 has Metal and Plastic, Product 3 has Metal and Glass.
The facet will obviously list Metal, Plastic and Glass.
What I am looking for is a method of filtering on the combination of elements if there is more than one value (Match All) but also on the individual value if there is only one (Match Any). If someone selects Metal and Glass, I want to display only Product 3. If it selects Metal, I want to show all 3 products.
My take on this request it's that it cannot be supported. but just to make sure, I am trying to figure out if there is a solution tested by somebody else.