How to calculate monthly churn rates

I am building a SaaS dashboard and am curious about how to perform some basic table-based calculations such as churn rate.

The churn rate formula is: Total Cancels During Period / Total Users at the Beginning of Period

My table consists of user_subscriptions and contains the user_subscription state and when the state was entered so I’ll need to aggregate these cancel counts and then also aggregate the total users per this period as well.

I am thinking that the table-based functions should work for this but am curious if there are any examples of how to do this as I am fairly new to QuickSight.

Hi,

You need a calculation field “Total Cancels During Period / Total Users at the Beginning of Period” and group it on “user_subscriptions”.

regards,
Naveed Ali