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)
-first ship month
Basically, if a customer has shipments, the first ship month should be 0, second ship month should be 1, etc.
It should look something like the chart above. (ignore actual percentage. will not match sample data)
Is there a dynamic way to create this?