4 Replies Latest reply on Jun 20, 2012 1:23 AM by haskebrukx

    How to count repeat purchases

      I'm trying to make a workbook showing how many repeat purchases (from existing customers) our company gets each day. I got a dataset with all the order and customer information.

       

      Simplified the data is like this:

       

      DateOrder-idAmountCustomer e-mail
      01-01-2012100150peter@company.com
      02-01-2012100260anne@company.com
      03-01-2012100350peter@company.com
      10-01-20121004100john@company.com
      17-01-2012100550peter@company.com

       

      Is it possible to have a calculated field that counts the number of times a particular value (e-mailadress in the example above) was already present in the dataset? My purpose if to be able to show that on 03-01-2012 and 17-01-2012 we got repeat purchases (a 2nd and 3rd order from a customer). Is that possible with a calculated field?

       

      The data would then have to look like this:

       

      DateOrder-idAmountCustomer e-mail
      Repeat purchase (calculated)
      01-01-2012100150peter@company.com1
      02-01-2012100260anne@company.com1
      03-01-2012100350peter@company.com2
      10-01-20121004100john@company.com1
      17-01-2012100550peter@company.com3