Need your help on whether below usecase can be achived
How to create a segment in AEP to find the users who visted the product but not purchased it. Say user visits two product pages(P1 and P2) and bought one product(P1) only. How to create the segment for this use case in AEP where user has purchased a product P1 but not P2. How AEP understands or basically group the events based on product and find that the P2 has not been purchased.
I was able to do it say a positive use case with single product but not with multiple views of the same product or multiple products
Include audience who have at least 1 Any event where ((Value equals 1 andValue does not exist happening in a single event))
select _Any1 from xEvent where _Any1.commerce.productViews.value = 1.0 and _Any1.commerce.purchases.value.isNull()