How do I calculate an average retention rate

DaniBoy
DaniBoy

domo

💎
in Card Building

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!

Dani aka "Mr.Dojo"

Dojo Admin
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
**You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.

Best Answer

  • jmo
    jmo
    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"
This discussion has been closed.

Categories