Customer 'Journey' by Sale Source

[lgbuss]

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

[v-qiuyu-msft]

Hi @lgbuss,

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

Best Regards,
Qiuyun Yu 

[lgbuss]

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