7 Replies Latest reply on Mar 14, 2016 11:39 AM by Derrick Austin

    calculating first time customers?

    tommy durant

      I want to be able to count the number of new customers per month.


      My dataset is


      Location: Customer ID: Transaction Date: Transaction Amount



      I am trying to think of a way to flag first time customers.  Would returning the max date and then its respective month. and then creating a field that says if todays month= max date month, then "new customer". be the way to go about it?