Forum Discussion
How to find customers visiting other shops for the same product in my shop within 14 days
mathetes hi there! first of all thank you so much for your prompt reply. Here's a link to a sample data: https://1drv.ms/x/c/8617be1dd00f6dd2/EXqCwnt94_hFo_nE6EmpiV8BrqJLPZXUJnjhJ0WmDGDoyg?e=zWhGSw
An interesting challenge. I've only been able so far to take it part way, via multiple steps. So I'm posting it in the hopes that one of the more savvy experts around these parts can show both you and me how to deliver the desired result in one single formula/query.
What I've done enables you very slowly to run through the products you've sold, one-by-one, see whether any other store has sold the same to the same customer. Try it, changing the product shown in the yellow box--the only ones YOU have sold per the mock database--and you'll see that there are only two instances where you and another store have sold the same product, and those are not ever to the same customer.
Here's the closest answer (same product within two weeks; but different customer)
But unless I'm missing something, the answer to your original question (from this mock data) ...
I need to find the customers visiting other shops for the same product in my shop within 14 days.
... is "Nobody"