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;

       

       

       

       

      Nabil