How to show number of repeated customers?

[#1]

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?

[sunny_talwar · Accepted solution]

Can you check the attached

[#3]

If I use Distinct Count instead of count, it will be exactly what I want to achieve. Thanks for the great help.