1 Reply Latest reply on Feb 26, 2016 7:03 PM by dipesh.patel.4

    Persistency chart

    dipesh.patel.4

      I am looking to create a persistency chart to track % of shipments month by month.

      y axis: percentage

      x axis: month number (starting at 0 which is the first ship month)

       

      In my data set, I have:

      -customers ID's - (some of which have shipments and some don't)

      -ship dates

      -ship month

      -first ship month

       

      Basically, if a customer has shipments, the first ship month should be 0, second ship month should be 1, etc.

       

       

      persistency example.jpg

      It should look something like the chart above. (ignore actual percentage. will not match sample data)

      • 0 should always 100%
      • 1 is # of customers with shipments in the month after their first ship month / # of customers in month 0
      • 2 is # of customers in with shipments in the month after their second month / # of customers in month 1.....etc

       

      Is there a dynamic way to create this?