4 Replies Latest reply on Sep 3, 2013 2:11 PM by Jim Wahl

    How to calculate survival curve / measure as % of total from other count

    Tim Reilly

      I'm trying to calculate a survival / death / lifetime curve from source data similar to what's below:


      SOURCE DATA:

      Customer IDConversion dateCancel date
      11/1/2013NULL
      21/2/2013NULL
      31/3/2013NULL
      41/4/2013NULL
      51/5/2013NULL
      61/6/20132/1/2013
      71/7/20133/1/2013
      81/8/20134/1/2013
      91/9/20135/1/2013
      101/10/20136/1/2013
      112/1/2013NULL
      122/2/2013NULL
      132/3/2013NULL
      142/4/2013NULL
      152/5/2013NULL
      162/6/20132/1/2013
      172/7/20133/1/2013
      182/8/20134/1/2013
      192/9/20135/1/2013
      202/10/20136/1/2013

       

      DESIRED OUTPUT:

       

      Conversion classOriginal class size% remaining
      1/1/20132/1/20133/1/20134/1/20135/1/20136/1/2013
      1/1/201310100%90%80%70%60%50%
      2/1/20131090%80%70%60%50%

       

      I can calculate both the count of original class size and a count of customers remaining by month separately, but cannot for the life of me figure out (a) how to get them to show up at the same time, and (b) how to create the formula to calculate the percentage surviving, i.e. a count of users remaining by month over the original conversion class size.

       

      Any help is much appreciated - sample data above attached.