1 2 3 4 5 6 113 Replies Latest reply on Feb 13, 2019 7:29 PM by Selvi velraj Go to original post
• ###### 45. Re: Sankey diagram made of dynamically generated polygons

1 of 1 people found this helpful
• ###### 46. Re: Sankey diagram made of dynamically generated polygons

Hi Olivier,

First, Thank you for the amazing viz and tutorial! I have implemented everything just fine but am having an issue that I can't resolve. I am unable to save the sorting and color of my step 2 bar and Sankey A sheets. If I modify the sorting and color and close the workbook it reverts to the default upon reopening. Have you ever seen anything like this?

Thanks!

Eric

• ###### 47. Re: Sankey diagram made of dynamically generated polygons

Got a vertical line of shapes to the right of the graph (see below for the part in the red circle). Any idea how to remove them? Thanks!

• ###### 48. Re: Sankey diagram made of dynamically generated polygons

Hi, you must have an issue with your densification data. Should be somewhere around t = 5.75 as far as I can see.

Let me know whether this works

Best regards,

Olivier

Le 5 mai 2016 à 15:51, Shu Zhang <tableaucommunity@tableau.com<mailto:tableaucommunity@tableau.com>> a écrit :

Sankey diagram made of dynamically generated polygons

réponse de Shu Zhang<https://community.tableau.com/people/shu.zhang?et=watches.email.thread> dans Viz Talk - Afficher la discussion complète<https://community.tableau.com/message/487362?et=watches.email.thread#487362>

• ###### 49. Re: Sankey diagram made of dynamically generated polygons

Hi Olivier,

Thank you for amazing work...quick question - I replicated your polygon with my data but I have way complicated data and I need to layer to 5 levels (compare to your sample of 3 levels)...but at level 4 its not aligning... is there any trick for level 4 & 5 that I am missing? (Below image shows how level 3 to Level 4 is not aligning)

Thanks

• ###### 50. Re: Sankey diagram made of dynamically generated polygons

Hi,

I would suggest to check your table calc configuration. It looks like the upper bar is not configured at the same level than the curve.

Let me know whether this helps.

Best regards,

Olivier

Le 5 mai 2016 à 18:35, hiten.doshi <tableaucommunity@tableau.com<mailto:tableaucommunity@tableau.com>> a écrit :

Sankey diagram made of dynamically generated polygons

• ###### 51. Re: Sankey diagram made of dynamically generated polygons

Tried taking out the rows in the "Model" sheet where t equals 6 or -6 and still saw those white shapes on the right of the graph...

• ###### 52. Re: Sankey diagram made of dynamically generated polygons

Hello Olivier,

Thanks for sharing this post. It was really helpful in getting me started with making a sankey in tableau. I followed all the steps you mentioned but for all my plots I am getting just 4 sigmoid curves. Can you please take a look and let me know where am I making a mistake. I am making a sankey plot with 4 levels.

I have attached the link to the dashboard below.

I will highly appreciate your help on this.

Thanks,

Kapil

• ###### 53. Re: Sankey diagram made of dynamically generated polygons

Hi Kapil,

At first sight, I see 2 curves with min and max not connected the right way. Try to place « Path » pill on the « path » mark of the polygon shape. If this don’t work, I suggest to review your table calc configuration.

This should do the job.

Cdt,

Olivier

• ###### 54. Re: Sankey diagram made of dynamically generated polygons

Hi Olivier,

I followed your example and built a sandkey diagram, but i need to set the link color one by one (so link color in step 1 & 2 are consistent).

Can tableau set the link color automatically?

Howard

• ###### 55. Re: Sankey diagram made of dynamically generated polygons

Thank you very much Olivier!

My only question is: Your method, as well as Jeff's rely on preparing the data by numbering the different categories in order to achieve the right curve lines. It is fine when I want to had craft a visualization for a specific static data.

However, if I want to put a Sankey diagram as part of an everyday dashboard for managers, how shall I treat the data? Shall I run every new line through an ETL process which will number it or there is another way which I am not aware of?

Thanks,

Mark B.

• ###### 56. Re: Sankey diagram made of dynamically generated polygons

I have the same question. My boss wants to put patient movements into a Sankey diagram and we have lots of data.

• ###### 57. Re: Sankey diagram made of dynamically generated polygons

Can you share that query, please?

• ###### 58. Re: Sankey diagram made of dynamically generated polygons

Hi Ramin & Mark,

If you wish to lower the dataset size, I suggest to use custom SQL query where you could aggregate the measures you would use for the flow size (e.g.: number of lines, count of students...) grouped by each dimension you would like to show your flow with. You would then end with 1 row for each Dimension 1 - Dimension 2 - Dimension 3... unique association.

So for exemple, if you have in your original data :

Student 1 - Spec 1 - Grade 1

Student 2 - Spec 1 - Grade 1

Student 3 - Spec 2 - Garde 1

you would then have :

Spec 1 - Grade 1 - 2 students

Spec 2 - Grade 1 - 1 student...

This method can considerably lower the dataset size and can also be processed within an ETL or a data prep tool.

Another trick would be to lower the densification by building not so smooth curves. In the following example, I have filtered the T to show what would the curve look like :

On the first half, I have kept all the T values. On the second half, I just kept T = 0, 5 and 6.

Finaly, you can use Tableau Extract.

The only thing that cannot be optimized is the calculations in themselves that will require hardware power.

I hope this will help.

Olivier

• ###### 59. Re: Sankey diagram made of dynamically generated polygons

Hi all,

I jus finished this one... what do you think ?

Cheers

Olivier

1 2 3 4 5 6