Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello! I've tried searching everywhere to no avail. Here's hoping perhaps someone might be able to point me in the right direction. I'm trying to figure out how to show the number of customers along a journey path.
Product A
1st Sale
100 customers is from website
25 customers is from mobile
20 customers is from retail
2nd Sale
100 from website
10 from mobile
2 from retail
3rd Sale
20 from website
3 from mobile
1 from retail
et cetera
My data source is set up in this way:
userid | product_id | timestamp | source |
user 1 | a | 02:00 | retail |
user 2 | b | 03:00 | website |
user 3 | b | 05:00 | website |
user 2 | c | 09:00 | website |
user 4 | a | 10:00 | retail |
user 2 | b | 12:00 | mobile |
user 1 | a | 13:00 | mobile |
Hi @lgbuss,
How do you determine it's 1st sale, 2nd sale, 3rd sale,..etc?
Best Regards,
Qiuyun Yu
@v-qiuyu-msft Thank you so much for the swift reply!
I'd like to determine if it's the fist sale based on the timestamp. So, User 1's first sale of product A was Retail. User 1's 2nd sale of product A was mobile, et cetea.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |