0 Replies Latest reply on Jul 11, 2012 8:36 AM by navid.scheybani

    How can I calculate revenue from relative data?

      Hi all,

       

      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!