Forum Discussion
littlemojopuppy
Community Champion
6 years agoCustomer Retention Calculation Over Successive Weeks
Hi! Looking for a little advice. Requirement is to calculate the number of customers who logged in on a given date, and then who logged in again in each of of the six one week time periods from tha...
littlemojopuppy
Community Champion
6 years agoGood morning!
Using CALCULATETABLE isn't mandated. Need to find those users that logged in in each of the six weeks and I can certainly try this out. Was hoping that I could avoid having to list out each successive week but I may not be able to.
I found this article by marcorusso on implementing compound interest. Compound interest calculations have to build on successive periods so I thought I would try it, but not hopeful that it would work because the formula would return values for periods and not groups of users/IdentityIDs from each period. That's really where it gets stuck...
Thanks for looking at it again.
littlemojopuppy
Community Champion
6 years agoSo the code I originally posted was the only thing that worked successfully. But thank you for your input! 😊