I have a table with users and a table with transactions. My data source is a left join
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?
Have you tried something like this?