4 Replies Latest reply on Aug 25, 2016 10:59 AM by james.diaz

    Identify set of users who started with amex and changed to visa

    james.diaz

      Hi, all. I have the following fields:

       

      - user_id

      - date

      - card_type (eg, amex, visa, mastercard)

       

      How could I create a set (or LOD calc?) of users who have an amex tied to their earliest (date) record, but a visa for their last?