Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ronald
Contributor III
Contributor III

Count Unique by dates

Hi everbody,

I need to count by the name field, but I have sales on different dates to the same Customer.
I attach the example.

Carlos has sales to different clients (M1, M2, M3) but to M1 he has three sales in the same month, for the count it should only be considered as one sale; and one to M2 and one to M3, total Carlos three sales.
Sandra has two sales to the same M4 customer, and overall Sandra must be one sale.
Total Maria a sale

visitas unicas.PNG

Labels (1)
1 Reply
GaryGiles
Specialist
Specialist

I think you are looking for:

count(Distinct [Customer])