Percent of Total( Initial Cohort)

[Juan]

Hi guys
I have a query to get the % that represents each cohort cell taking as reference the initial cohort(cohort index = 0). For example, let’s take July 2024, where we have 611 as cohort for that month, the next month(cohort index = 1) there are 378 customers who continue to buy, so their percentage would be 61%; it should be like this for the rest of the cohort index. But I can’t do this due to aggregate function limitations. The cohort index field is calculated as follows
dateDiff({Month Record},{created_at},‘MM’)
Month Record is the minimum date for each user.
Is it possible to have the percentages calculated horizontally from left to right considering as denominator the cohort index = 0?

[duncan]

Hello @Juan !

Have you tried the marked solution from this topic?

Calculating retention %

Hello, I am looking into creating a retention table, and I have managed to make a pivottable using a calculated field [Datediff Active Date, User created date] combined with [distinctcount User ID] and it’s giving me what I need in user numbers, but I am struggling with making it into a %, maybe because I am using [distinctcount User ID]. It just does not seem to give me the option to play with percentages at all. [image] Does anyone have an idea if I can somehow work this out with calculate…

[Juan]

Hi @duncan , i use the solution that Jooni proposed, and it works just fine, thanks!