1 of 1 people found this helpful
Thank you for the comment.
But I am not sure what you pointed.
Mine is already moving sum of 30 "points" with assuming all the dates has data (= previous 29 days + today) .
I meant that Subscriptions should be as of the date and not the last 30 day subscriptions. Cancellations are for the last 30 days.
Ah, I understood.
Hi Shin, Thanks for your help. I am also learning this process so I apologize in advance for the confusion. I like the approach you suggested. While Talking to the business in detail here is some more info on this -
What was the subs on Day 1?
What was the cancels on day 30?
Divide the cancels on day 30 by the subs on day 1.
This number should be called “Rolling 30 day churn”
If we take an example for the month of Oct -
As of Oct 1 - End of period subscribers.
Cancellations - From Oct 1 to Oct 31. ---This will be a rolling 30 day.
This is the pattern the business is looking for -
So the EOP subs should besame through out the month until Oct 31st.
Nov 1st we will have a new number 7000 which is the EOP subs as of Oct 31st
and total cancellations start from Nov 1st - Nov 30th .
If the user wants to go back and check churn rates in Sep then he should be able to change the date range and look at the churn rate in Sep.
Let me know if you have any ideas.
Thanks again for your help,
Hi Shin, Thank you very much for your help. Your suggestion worked. Thanks again, Vandana
You are very welcome.
Hi Shin, Just posted a timing calculation that i need help with. Can you please help? Thanks, Vandana