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

Olivier, this is fantastic! The Viz works beautifully! I have an issue though. If I expose SUM([Flow Size Indicator]) I get billions when I only have roughly 700M in my spreadsheet... Am I doing something wrong?

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

Actually I think I found the solution.

You to divide your SUM(Flow Size Indicator) by the "magic number" 98 when you want to show totals in the polygon.

I created a "Poly Indicator" calculated field.

I added a spark line on top of each flow to show Gross Sales, Gross Units, Average Price Annual Trends

And colored dots to indicate the Compound Growth

Thanks again Olivier, I LOVE this view!

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

Hi Oliver,

Thanks for the stepwise blog, its great, I have tried recreating my own version but I am facing an issue at Sheet 2 which is for Curve 2. It is not being displayed when I use Curve Polygon 2 attribute and it says "The table calculation for curvePolygon 2 requires a field that is missing , kindly advice.

I would also need end-to-end highlight/select if I select one curve in the sankey. Please find my workbook and sample excel sheet attached.

I would really appreciate if anyone else can also look into the workbook and tell me the issues.

best regards,

Mohit

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

Thanks for this...  outstanding work!!

note:  you can eliminate half or more of the points along the sigmoid and still get graceful curves... eliminating all but the beginning and end will yield some very Art Deco parallelograms!

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

Great post, thank you for posting it!

However, if I wish to show the total numbers (i.e. the starting and end position on the bar charts) on either as a label on the graph or in the tool tip - does anyone know how to go about that?

As well if it is possible to get this integrated in my original data, not as a separate excel sheet? Looking to make it automated for instead of extracting data, and then copy-paste in to the excel template posted here. Or the best way to link/blend/join to my data set as it on different levels of aggregation? This is in order to filter the Sankey and have it more integrated in the analysis/dashboards.

Thank you in advance, any help is appreciated!

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

Mohit, Because you are creating steps all your calculations will also have to be done for those with the new steps; Everything from at least step 5 of this thread, since you have new steps, you need new calculations.mohit huria

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

Hi All. I’m new to the forum but I’ve spent a few weeks working on an alternative model to this which I’ll post when I get a second to anonymise the data.

In reply to your question about integrating in to the original data, I am half way through this. First of all I created my own excel template which I want all my queries (BigQuery) to take the consistent metadata form of. This was a really good way of learning how to replace the data sources so I didn’t keep having to run queries. I had to go in to all the calculations and edit the advanced table calculations to pick up new field names. I am next going to write my queries with the same column headings, load the polygonal model in to a BigQuery table and extract the data straight in to the tableau data store in an automated fashion.

I’ve added lots of labels in to my tooltips which again I had a few issues with but I added them in to the ‘detail' of the viz making sure they were ignored in table calculations. Sometimes I had to go in to the table calculations and add them in to the partition in the advanced options of the calculation if they were a descriptive column. You’ll have to go and manually update the tooltip I find.

I had to divide all my clicks (this is being used as a website flow dashboard) by 98 because of the amount of rows in the polygonal model so keep an eye on that if you are referencing actual values and not percentages.

I’m really sorry if this is waffly, I will post my workbook when I get a chance.

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

This is great.

Has anyone done this connected live to a SQL database rather than using extracts?

David

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

Your work is absolutely amazing, but is it normal that whenever i wish to attach the polygonic data with any other data via link and link that suddenly every single data row dissapear? :X
It would seem that from using the excel data received, which im very thankful for.

That this problem will occur for me, i drag the two research data with one link column and innerjoined it with the polygonic data.

It all dissapears, what am i doing wrong. Sorry for any inconveniences caused

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

Hi David,

I converted this example to a SQL-based version.

You have to use Custom SQL to get the Model in. I wrote a query that impersonates a table (without creating the table) and joined it to the data I was using.

I chose this route since it's not necessary to create a table for the Sankey model as the data is always going to remain the same and will never be grouped/filtered in any way.

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

Wow Bill! In addition to the hover action I liked how lean your logic is - no usage of sets, parameters etc. Thanks a bunch for sharing.

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

Hi Olivier,

First of all, thank you for sharing great dashboards with us!

I have tried to replicate the decision tree using polygons, but I seem to be missing something. Could you please point out what I'm doing wrong?

Thank you!

Igors

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

Hi Lee,

According to your capture, you probably have some advanced table calculation wrongly set for some calculation. Make sure that all you table calc are properly defined as described in the initial post and this should work correctly.

Regards

Olivier

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

Hi, problem solved! I just needed to recreate the viz after editing the table calcs, I had thought this might be automatic.

Thanks for the viz instructions, this is awesome!

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

WOW!

I saw Jeffrey's vlog and can't wait to bring these into my own work. Thank you!

I've bookmarked you for future reference!

--Michael

1 2 3 4 5