CODEWITHSUNDEEP
amazon-quicksight
qusai safa
qusai safa

Reputation: 44

AWS QuickSight Cohort(customers returning rate)

I am using AWS quickSight for anyltics. I have a data set contains customer, orderDate, order I want to create a cohort report showing the customer return rate. so assume in the first month I have 100 new customers, I need to show in the next months how many customers from the 100 is returning to use my service.

Example

month 0 month 1 month 2 month 3
Jul, 2022 200 50 20 29
Aug, 2022 250 100 30
Sep, 2022 300 70
Oct, 2022 330

in the example above, in Jul I have 200 new customers, from the 200 customers in the next month 50 customers returned to use our service, then in the second month, 20 customers from the 200 customers return to use our service, and so on.

is this doable using AWS QuickSight, Please share your thoughts

Thank you in advance.

Upvotes: 0

Views: 541

Answers (1)

bikoman57
bikoman57

Reputation: 126

Please check this How to Perform Cohort Analysis

I think it will answer your question.

Upvotes: 1

Related Questions