2 Replies Latest reply on Jul 18, 2018 6:17 PM by Joana Priou

    Create a status if row are repeated

    Joana Priou

      Hi,

       

      I have a lot of rows with Purchase date, Email (Customer ID), Order ID and quantity.

      I am looking at repeat purchase, to do I created the first purchased date {Fixed [Email] : Min[Purchase Date]}.

      I then created a field repeat purchase status IFF([First purchased Date] = [Purchase Date], "New","Existing").

       

      The issue is  that I am facing is that I have people that did a second or third purchase on the same. I would like to check how to exclude them.

       

      Thanks