I would like to create a calculated that would show when their is a churn/add.
My data is structured like below.
Imgur: The most awesome images on the Internet
Basically, when a customer has revenue month 1 and no revenue month 2, that is a churn.
When a customer has no revenue month 1 and revenue month 2, that is a add.
The only way i can do this, is by creating a ton of calculated fields. It seems like i should be able to do this in 1 or 2. Any idea on how to set it up?
attached workbook with sample data .
Not sure but find my approach based on quick calc as reference below and stored in attached workbook version 10.0 located in the original thread.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...