Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Trying to create a user retention rate chart, input would be userid/date, and output would be given a certain date, how much percentage of user returned on a future date up to today, see below sample, I dont really have a clue, so any pointers are appreciated.
input
user_id | date |
a | 5/1/2020 |
a | 5/2/2020 |
a | 5/3/2020 |
b | 5/1/2020 |
c | 5/1/2020 |
c | 5/2/2020 |
d | 5/1/2020 |
e | 5/1/2020 |
f | 5/1/2020 |
g | 5/1/2020 |
output
5/2/2020 | 5/3/2020 | 5/4/2020 | 5/5/2020 | 5/6/2020 | 5/7/2020 | |
5/1/2020 | 10% | 8% | 7% | 12% | 9% | 8% |
5/2/2020 | 4% | 5% | 20% | 3% | 4% | |
5/3/2020 | 6% | 6% | 6% | 6% | ||
5/4/2020 | 6% | 6% | 6% | |||
5/5/2020 | 6% | 6% | ||||
5/6/2020 | 6% |
5/7/2020 is the max date from input table (or just today to make it simpler). The table is read as 10% distinct users who visited my website on 5/1 returned on 5/2.
Hi , @dengydongn
Could you please tell me whether your problem has been solved?
If it is, please mark the helpful replies or add your reply as Answered to close this thread.
More people will learn new things here. If you haven't, please feel free to ask.
Best Regards,
Community Support Team _ Eason
@dengydongn , Very similar to cohort Analysis, refer if these can help
https://finance-bi.com/power-bi-cohort-analysis/
http://funbiworld.com/2019-12-02-cohort-analysis/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |