5 Replies Latest reply on Aug 1, 2018 6:33 PM by Ken Flerlage

# Sankey starting lines

I just build my first Sankey diagram in Tableau and it's working out how I want and pretty good...for the most part. I'm getting slightly upset by the fact that on the left side I have 5 marks for each individual but the 5 marks are not evenly spaced. I would like to have each mark ultimately converge into the same value, on the left and right side, but can't quite figure it out. Any help with the formulas or just formatting would be appreciated.

I've attached a packaged workbook with only about 1/5 of the data.

• ###### 1. Re: Sankey starting lines

Hi Spencer,

BR,

bharat

• ###### 2. Re: Sankey starting lines

That's not helpful. Each person has 5 lines that comes from them. The 5th line for one person and the 1st line for the next are closer to each other than the 1st and 2nd lines or 4th and 5th lines are. Here's a picture:

This means as more data is added some of the lines stop lining up as nicely:

In the above example the 5th line (red) belongs to the top individual but it looks like it is more grouped with the second. I'm wanting to modify the actual value of the Curve measure so that all 5 values for each individual equal the same number. For example I want all of Katie's to equal .0744 and all of Bob's to equal .2176.

• ###### 3. Re: Sankey starting lines

I'm not completely sure what's causing the spacing differences, but I see a couple of other problems with this, including the fact that some of the names don't line up with the curves and the fact that the curves aren't smooth. I'm wondering if you might consider a different method of creating your sankey. I created a simple template for a sankey recently, which might work well for you: Chart Templates Part 1: Sankeys - Ken Flerlage: Analytics Architecture, Strategy, & Visualization

I put your data into it and created this:

I've attached the workbook and the source data file, in case you're interested in this modified approach.

1 of 1 people found this helpful
• ###### 4. Re: Sankey starting lines

This seems like a great fix for my problem. Thank you! I'll dive in and try to understand what you did.