I am trying to create a cohort analysis with the % retention, month after month.
I have created a cohort table with absolute numbers, but I cannot calculate a percentage of the total for each cohort.
For example: I am trying to calculate the numbers within the pivot table as a percentOfTotal
, where the total should be the distinctCount
of created_at
for each month.
Does anyone have any ideas ?
Thanks!