Forum Discussion

Binway's avatar
Binway
Icon for Helper II rankHelper II
5 years ago
Solved

Sankey not creating a single node for to and from

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

Need Help
  • Binway's avatar
    Binway
    5 years ago

    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

3 Replies

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    5 years ago

    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's avatar
      Binway
      Icon for Helper II rankHelper II
      5 years ago

      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's avatar
      Binway
      Icon for Helper II rankHelper II
      5 years ago

      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