Sankey not creating a single node for to and from

[Binway]

Hi Team,

I have created a Sankey chart and wanted it to be like the example where a node that has a flow in and out is placed in the centre.

Such as for Portugal or South Africa below.

example

My data is similiar in that it has source, target and count but the Nodes do not seem to group where there is a flow in and out.

How do I format the chart or data so it would look similiar to this where the FI_1 node has been grouped into a single node.

Thanks

[Icey]

Hi @Binway ,

I have done some research and tested, but no direct way to achieve your requirements.😔

I'll do more research to understand the logic of Sankey visual and check if there is any workaround.

Best Regards,

Icey

[Binway · Accepted solution]

So it would seem that the data needs to be transformed a wee bit. I removed the line where FI_1 was both the source and target.  I also changed the names to indicate they are a source or target.  It seems to get it's knickers ina twist if there is a circular flow happening where the source and targets are the same name.

So the data now looks like this:

And produced the desired result where the focus in on the name FI_1:

Thanks for looking into this

Binway

[Binway]

Thanks Icey,

Interestingly when you download the sankey viz sample data and compare it to my data there does not appear to be much of a difference.  There is a source, destination and measure fields where a value can be in the source and destination eg South Africa, France appear in both source and destination so appear with flows coming in and going out.

This sample data does not seem to be much different to my data where values are in the source and destination column, is there some option i need to turn on.

Thanks

Binway