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.
1 of 1 people found this helpful
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.
This seems like a great fix for my problem. Thank you! I'll dive in and try to understand what you did.
Great. Glad it's helpful Spencer!!