
1. Re: Churn Rate Calculation
Shinichiro Murakami Oct 20, 2017 5:57 PM (in response to Vandana Samtani)Hi Vandana
I am not sure I'm on the right track or not, but this might help?
Moving_sum last 30 data points including today
Thanks,
Shin

Sample_Win_sum_SM_10.2.twbx 32.2 KB


2. Re: Churn Rate Calculation
Hari Ankem Oct 20, 2017 6:31 PM (in response to Shinichiro Murakami)Shinichiro: I guess the subscriptions should be cumulative till date since Vandana mentioned as of date.

Churn Rate.twbx 32.9 KB


3. Re: Churn Rate Calculation
Shinichiro Murakami Oct 20, 2017 6:49 PM (in response to Hari Ankem)1 of 1 people found this helpfulHi Hari,
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) .
Thanks,.
Shin

4. Re: Churn Rate Calculation
Hari Ankem Oct 20, 2017 7:07 PM (in response to Shinichiro Murakami)I meant that Subscriptions should be as of the date and not the last 30 day subscriptions. Cancellations are for the last 30 days.

5. Re: Churn Rate Calculation
Shinichiro Murakami Oct 20, 2017 8:19 PM (in response to Hari Ankem)Ah, I understood.
Shiin

6. Re: Churn Rate Calculation
Vandana Samtani Oct 25, 2017 3:20 PM (in response to Shinichiro Murakami)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,
Vandana.

7. Re: Churn Rate Calculation
Shinichiro Murakami Oct 25, 2017 7:31 PM (in response to Vandana Samtani)
Sample_Win_sum_SM_10.2_v2.twbx 33.6 KB


8. Re: Churn Rate Calculation
Vandana Samtani Nov 6, 2017 6:13 PM (in response to Shinichiro Murakami)Hi Shin, Thank you very much for your help. Your suggestion worked. Thanks again, Vandana

9. Re: Churn Rate Calculation
Shinichiro Murakami Nov 6, 2017 6:19 PM (in response to Vandana Samtani)Hi Vandana
You are very welcome.
Shin

10. Re: Churn Rate Calculation
Vandana Samtani Nov 6, 2017 6:31 PM (in response to Shinichiro Murakami)Hi Shin, Just posted a timing calculation that i need help with. Can you please help? Thanks, Vandana