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

  • jmo
    jmo Domo Employee
    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"

Answers

  • jmo
    jmo Domo Employee
    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.