Hi everyone, I am trying to create a month over month table for user retention and churn. Retention: If a user visited in current and previous month, then retained user Churn: If a user visited in previous month but not in current month, then churned user My data is essentially website visit lo…

I have already reviewed this, unfortunately it does not solve my use case exactly. Since I am trying to flag the users who visited in current month & previous month and then distinct count them and report next to current month essentially.

[image] Pankhuri: Hi everyone, I am trying to create a month over month table for user retention and churn. Retention: If a user visited in current and previous month, then retained user Churn: If a user visited in previous month but not in current month, then churned user My data is essenti…

@lary_andr Unfortunately this won’t work for me as I am trying to make this a dynamic calculation within Quicksight. Such that the users can select custom time periods and check the retention. I have solved this within a SQL query but then the dynamic nature within QS goes away

Hello @Pankhuri If you use dataset parameters with direct query you can use the parameters in your analysis and dataset, retaining the dynamic ability of Quick Sight. Using dataset parameters in Amazon QuickSight - Amazon QuickSight Learn how to use dataset parameters in Amazon QuickS…

Hello @Pankhuri Since we have not heard from you in some time this topic is being archived. If you still need help, please feel free to post a new topic at the top of the community so that it is a priority for community experts. You can link this old topic in your new post.

Calculating MoM retention and churn

Q&A

Shahid_Muhammad April 25, 2025, 11:57am 2

Please see below this can be helpful for you.

MoM calculation variations - Question & Answer - Amazon Quick Sight Community

Topic		Replies	Views
Retention and Churn - Checking previous month's status as of current calendar date Q&A quick-sight , calculations	3	2229	May 18, 2023
Calculating client retention and churn Q&A analysis , filters , error , quick-sight , level-aware , filters-controls-and-parameters , calculations , visual , Business-Intelligence-Engineer , kpi	9	592	April 16, 2024
Retention by visits % Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	3	300	March 26, 2024
Calculating the percentage difference against the initial distinct count and not the previous column in a Pivot Table Q&A analysis , quick-sight , calculations	5	2038	July 13, 2022
Retention rate calculation Q&A quick-sight , calculations , Business-Intelligence-Engineer	3	321	March 15, 2024

Calculating MoM retention and churn

Related topics