topic Re: Calcalate Customer Retention Rate in App Development

Calcalate Customer Retention Rate

prabunakil — Sat, 16 Nov 2024 06:36:53 GMT

Hi I need help.

i have data like below:

Customer ID	Join Year	Purchase Date
1	2016	01.02.2017
2	2017	01.02.2017
2	2017	01.02.2018
2	2017	02.02.2019
3	2016	28.01.2016
3	2016	15.01.2017

I want to calculate number of customer who no purchase more then five month.

Based on the table provide. The answer should be:

Customer ID: 1 and 3.

How to calculate based on this.

Re: Calcalate Customer Retention Rate

gn_marvs1989 — Tue, 12 Feb 2019 13:39:23 GMT

If you just wanted to show that in a chart or table, you can just use a set analysis on the expression:
count({<Purchase Date={"<$(=AddMonths(Today(),-5))"}>} Customer ID )

Re: Calcalate Customer Retention Rate

pradosh_thakur — Tue, 12 Feb 2019 13:52:38 GMT

Make sure [purchase date] is in date format and not string.

count(distinct {<[Purchase Date]={">$(=AddMonths(Today(),-5))"}>} [Customer ID] )

Re: Calcalate Customer Retention Rate

prabunakil — Tue, 12 Feb 2019 13:55:17 GMT

Date(Floor( Date(AddedDate)),'DD/MM/YYYY') as PurchaseDate,

My Purchase Date is as per above.

Re: Calcalate Customer Retention Rate

prabunakil — Tue, 12 Feb 2019 13:58:42 GMT

I follow ur dimension and i getting as below:

Re: Calcalate Customer Retention Rate

prabunakil — Wed, 20 Feb 2019 02:43:58 GMT

Hi, i am still unable to calculate it.