Retention Rate cohort analysis

[Nico]

Hi @xyz27 ,

welcome to the community

Do I get this right? Your visual shows all users that activated in Q1. The activation month is in the first column.

And as an example 1000 of the users that activated in Jan also canceled in Jan?

Can you offer us some kind of example data and store it in Amazon Arena?

NEW - QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community

[FeatureTile] QuickSight Arena provides you with an embedded instance of QuickSight right within the QuickSight Community. Using Arena, you can: Publish dashboards to the Community Gallery to showcase your skills Include dashboards depicting your use case while posting questions in the Community Q&A Clone underlying analysis views of published dashboards in order to learn / try answering questions Include dashboards, with working solutions, while responding to questions In this article, …

I created an example on Amazon Arena:
PivotTable

If this is what you want, there is no need for a calcualtion. Only a Pivot Table and the aggreagtion to Month.

Best regards,
Nico