Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lgbuss
Regular Visitor

Customer 'Journey' by Sale Source

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:

 

useridproduct_idtimestampsource
user 1a02:00retail
user 2b03:00website
user 3b05:00website
user 2c09:00website
user 4a10:00retail
user 2b12:00mobile
user 1a13:00mobile
2 REPLIES 2
v-qiuyu-msft
Community Support
Community Support

Hi @lgbuss,

 

How do you determine it's 1st sale, 2nd sale, 3rd sale,..etc? 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.