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?