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.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!