I want to calculate the cancelation rate for every month of user signups. For example, in the month of December, there have been 5 signups and 2 cancellations. I want to create a calculated field that spits out 40%.
When I try this (sample Arena dashboard included), I get this error: Table calculation attribute reference(s) are missing in field wells. This is my formula for the Cancelation Rate field:
I did a countOver as I need this for another visual where it needs to count all cancellations over all signups over the entire date cohort (e.g. one month; the calculation for this field is truncDate(“MM”, {signup_date})). I also want to do a runningSum of the cancellations divided by the total number of signups, but this is not working as well.
How could I solve these two problems? I appreciate your help!
I want to show this in a table ultimately and dont have space to select those two fields as well. Any other way I can change the formulas so I still get the desired output without needing to intervene at the data level?
thanks for your analysis and your continious help with this, I appreciate it!!! The problem with the Cancellation Rate 2 field is that it picks up the overall cancellation rate for each month, but not the cumulative cancellation rate for every cancelation day grouped by signup month.
In the end, we need a line chart visual that can depict the following:
on the x-axis we have “cancellation days”, which are the days between signup_date and cancelation_date.
on the y-axis we have the cancellation rate.
and we have multiple lines for each signup_date_cohort. For example, there would be one line for all November signups (let’s say there were 80 signups in November). On day 1 maybe 20 of them canceled, on day 2 maybe 10 canceled, on day 3 maybe 30, on day 4 maybe 0. The respective cancelation rate on the line graph should look like this:
