Create the data table for sankey diagram

[temptester]

I have a table like below and trying to create a sankey diagram using the free version.

Customer	Status	Date	applicatoin no	product	Before	After
1	in	1/1/2024	1	C	No	D
1	in	1/2/2024	2	D	C	No
2	out	1/3/2024	3	J	No	C
2	out	1/4/2024	4	C	J	M
2	out	1/5/2024	5	M	C	No
3	in	1/6/2024	6	C	No	L
4	in	1/7/2024	7	L	No	C
4	in	1/8/2024	8	C	L	No

In the sankey, I want to show the before->product->after sequence for each customer where product = "C" (highlighted). So its like souce-Before, middle-C, destination-After. Can you please help me create the data table for this. Thanks.

[temptester]

Sorry for the delayed response. I think the previous image wasn't clear. My actual dataset is too large and the names are long. So printing it in the middle is a bit cluttered. Can we make a similar Sankey?

[temptester]

Thanks for this. It works. But below is what I exactly wanted. I hope you can understand the drawing.

Customer	Before	Product	After
1	R	C	No
2	A	C	J
3	No	C	D
4	A	C	J
5	B	C	K
6	B	C	K

[temptester]

Thanks for this. Yes, it works. But what exactly I wanted is the below. I just did a drawing. Hope you can understand it.

Customer	Before	Product	After
1	R	C	No
2	A	C	J
3	No	C	D
4	A	C	J
5	B	C	K
6	B	C	K

[Anonymous]

Hi @temptester ,

According to the field information provided by Sankey visual, the best way to show this effect is to enable data link labels.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @temptester ,

You need to put the product field into source labels, and then turn on date link labels in the data format.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.