Hi... I am new in this amazing toll... and I have the following problem:
I have a set of 1,000,000 customers and they are set as parents of the event "purchase", which contains a list of products customers bought with a property "category".
I want to know which customers have NEVER bought a product with category = "shoes". If I use a MUST NOT in the query I will get all customer that have at least one "purchase" without a product with category = "shoes"... which is not the same thing a "NEVE HAS BOUGHT"
Is there a query that helps me get this info? Like (MUST NEVER HAVE... lol)