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