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 Quick Sight.