1 Reply Latest reply on Aug 29, 2012 6:59 PM by Dimitri.B

    After a one-to-many outer join.... (newb question)

      I have a table with users and a table with transactions.  My data source is a left join

      users.id=transactions.user_id

      If a user has at least one entry in the transactions table, they've made a purchase.

       

      I'm trying to look at the binary outcome of purchase/no purchase, and break it down by various columns in the user table.

       

      What is the best way to create this binary outcome variable?