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…

Calculating MoM retention and churn

Shahid_Muhammad April 25, 2025, 11:57am 2

Please see below this can be helpful for you.

Topic		Replies	Views
Retention and Churn - Checking previous month's status as of current calendar date Q&A quick-sight , calculations	3	2150	May 18, 2023
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	2006	July 13, 2022
User lifecycle analysis recommended approach Q&A charts , analysis , direct-query , quick-sight , pivot-table	3	652	October 6, 2022
How to calculate monthly churn rates Q&A quick-sight , calculations , how-to	1	820	February 14, 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	534	April 16, 2024