AnsweredAssumed Answered

counting unique customer ids in a found set

Question asked by ramonadorsey on Jan 20, 2016
Latest reply on Feb 29, 2016 by JuliaOlsen

I have identified a flag to determine whether a sale occurred on my database. however sometimes the same customer can have a sale on the same day or with in a 30 day period etc.   I want to flag it as a sale because I want to add up my sales volume total but I also need to count the number of unique customers that has a sale during that period.

 

right now ... I have a summary field that sums the told number of sales for a specified period.  but what I really want is the number of distinct customers that had a sale for a specified period ... say the last 30 days.

 

Can you point me in the proper directions... thanks,

Outcomes