I have a sequel which pulls the revenue of all the all by week. Bringing this into Tableau I will get a date dimension and a revenue measure.
Now I need to create some flags for their status with these two fields. How can I create a calculation which is like:
IF revenue(date last week) > 0 AND revenue(date this week) = 0 THEN 'Churn'
IF revenue(date last week) = 0 AND revenue(date this week) > THEN 'resurrected'
I really appreciate your help!
Retrieving data ...