How do I calculate an average retention rate
Greetings,
I am trying to calculate an average retention rate in my card and the numbers don’t validate when I take an average. I know the sum is not the right thing to do, any help would be appreciated.
Thanks!
Best Answer

You should always use a Beast Mode to calculate ratios. When you upload a ratio into a data source and then take an average you are weighting each individual ratio equally and this is almost never what you want to do. The correct Beast Mode logic for a retention rate would be as follows.
sum(`Customers Renewing`) / sum(`Total Customers`)’
This equation will always be correct no matter how you filter or drill.

I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"4
Answers

You should always use a Beast Mode to calculate ratios. When you upload a ratio into a data source and then take an average you are weighting each individual ratio equally and this is almost never what you want to do. The correct Beast Mode logic for a retention rate would be as follows.
sum(`Customers Renewing`) / sum(`Total Customers`)’
This equation will always be correct no matter how you filter or drill.

I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"4
Categories
 10.5K All Categories
 8 Connect
 918 Connectors
 250 Workbench
 473 Transform
 1.7K Magic ETL
 69 SQL DataFlows
 478 Datasets
 208 Visualize
 257 Beast Mode
 2.1K Charting
 12 Variables
 18 Automate
 355 APIs & Domo Developer
 89 Apps
 3 Workflows
 20 Predict
 5 Jupyter Workspaces
 15 R & Python Tiles
 247 Distribute
 63 Domo Everywhere
 243 Scheduled Reports
 21 Manage
 42 Governance & Security
 183 Product Ideas
 1.2K Ideas Exchange
 11 Community Forums
 27 Getting Started
 14 Community Member Introductions
 55 Community News
 4.5K Archive