How do I calculate an average retention rate



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. 



Best Answer

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