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
    Accepted 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.

This discussion has been closed.