Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm having a trouble with the set analysis. please find the attachment for better understanding.
I have a set of partners (restaurant/café), a set of customers and a set of transactions.
What I need to show is the number of repeated customers for each partner. Eg: Number of customers visiting 1st time, Number of customers visiting 2nd time and Num of customers visiting 3 or more times.
I have searched the community but couldn't find any answer to my problem.
What kind of aggregation or function can I use?
Can you check the attached
If I use Distinct Count instead of count, it will be exactly what I want to achieve. Thanks for the great help.