3 Replies Latest reply on Mar 13, 2018 1:36 AM by Nabil Majoul

    Finding the next date every record

    Nabil Majoul

      Hello Folks,

      need (again your help in this one).

      I have a data set of contract each uniaue contract ID has an activation and deactivation date.
      My fina goal is to calculate a churn . a contract being deactivated for a certain period.



      for this I figured I need to calculate a "next activation period" for each row;


      I digged arround and this post is a good sample to figure it out the second activation :

      Things Tableau — Find the # of days between the First Date and the Second date for a customer.

      But I need to do this for every reactivation of the contract:


      I hope this is clear and I attached a sample dataset.


      Thank you for your help;