-
1. Re: Need help on creating Sankey diagram
Walt Reed Dec 6, 2016 2:59 PM (in response to Neil Chakraborty)Hey Neil,
Taking a quick look at the spreadsheet and workbook, I have a couple observations:
- When you duplicated the data (as indicated in Step 1 in the blog post), I don't see where you created a field "RowType" that classifies the original data as "Real" and the duplicated data as "Dummy".
- This will be used to create the [ToPad] Measure as indicated at the beginning of Step 2 and will factor in on Step 5.
- Then, you'll create the [t] field within Tableau (instead of doing it within Excel).
- I would recommend creating the [sigmoid] field within Tableau. I had issues getting the [Curve] formula to work because Tableau was requiring you to add ATTR() to [sigmoid]. So once [sigmoid] is created in Tableau, the [curve] formula will be: [Rank 1]+(([Rank 2] - [Rank 1])* [Sigmoid])
Once you get here, the rest of the instructions seem pretty straightforward. I didn't want to try messing with/duplicating your data since I'm not familiar with it, so try these couple of things and let me know how it works out.
Walt
- When you duplicated the data (as indicated in Step 1 in the blog post), I don't see where you created a field "RowType" that classifies the original data as "Real" and the duplicated data as "Dummy".
-
2. Re: Need help on creating Sankey diagram
Neil Chakraborty Dec 7, 2016 1:39 PM (in response to Walt Reed)Thanks Walt. I still have the issue - I am trying to follow up on how to do it based on : Data + Science . Unfortunately, its been a tough road for me to mimic what Tableau developers have put up online.
I am still facing issues with the curve function when there is a count of cells involved. Basically, all I want is to show the number of overlap courses and languages. For example, the number of Anthropology students taking Chinese courses is only 8 across the years. I know there are more than manageable number of programs right now (about 40), but I can always aggregate those, once I have figured out a way to show the flow between courses and languages.
-
3. Re: Need help on creating Sankey diagram
Walt Reed Dec 7, 2016 2:17 PM (in response to Neil Chakraborty)Hey Neil,
I think I'm still unclear on how you prepped the data. Did you duplicate it (double it), or did you duplicate it 49x?
-
4. Re: Need help on creating Sankey diagram
Neil Chakraborty Dec 7, 2016 3:11 PM (in response to Walt Reed)Thanks Walt for the reply. As you rightly pointed out, I duplicated by 49x to give full range from -6 to 6.