Forum Discussion
Create the data table for sankey diagram
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.
5 Replies
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 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?
