7 Replies Latest reply on Jan 28, 2016 6:55 PM by Mathew Grimm

    Flag for First Order From Customer

    Mathew Grimm

      Given a dataset that has...

      • customer_id
      • order_id
      • date
      • amount

       

      ...what's the most efficient way for Tableau to handle a flag on a particular record that indicates it was the first order from a customer?

       

      An example task would be wanting to count the number of new customers so far this year.

       

      For example...

      Customer_ID, Order_ID, Date, Amount, First_Order?

      1, 100, 1/1/2016, $10, Yes

      1, 101, 1/2/2016, $10, No

      2, 102, 1/3/2016, $10, Yes

      3, 103, 1/4/2016, $10, Yes

      3, 104, 1/5/2016, $10, No

      etc.

       

      Thanks!

      Mathew