1 2 Previous Next 17 Replies Latest reply on Feb 29, 2016 1:52 PM by JuliaOlsen

    counting unique customer ids in a found set

    ramonadorsey

      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,

        1 2 Previous Next