How do I calculate an average retention rate
[Deleted User]
Member
in Charting
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!
1
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
This discussion has been closed.
Categories
 7.7K All Categories
 5 Connect
 921 Connectors
 244 Workbench
 479 Transform
 1.8K Magic ETL
 60 SQL DataFlows
 446 Datasets
 43 Visualize
 199 Beast Mode
 2K Charting
 8 Variables
 1 Automate
 348 APIs & Domo Developer
 82 Apps
 Workflows
 14 Predict
 3 Jupyter Workspaces
 11 R & Python Tiles
 241 Distribute
 59 Domo Everywhere
 241 Scheduled Reports
 15 Manage
 36 Governance & Security
 29 Product Ideas
 1.1K Ideas Exchange
 Community Forums
 14 Getting Started
 1 Community Member Introductions
 49 Community News
 18 Event Recordings
 579 日本支部