Sankey plot

Hi, the diagram given by DocMusher includes 6 destinations/layers (1st: "F", "M" and "?", ... ,6th: "Miserable" and "Non-miserable"). How was this realized in RM? The file sankey.csv given above includes only "from" and "to".

Cheers

Tom

Marco_Boeck

Hi Tom,

The "To" and "From" columns work like this:

Take all values from the "From" column which do NOT appear in the "To" column, as those are the starting nodes - there is no value that goes to them. These form the 1st layer.
The corresponding "To" colum value is now used to generate the 2nd layer.
Find all rows that have a value from the latest layer in the "From" column and use their "To" column to generate the next layer.

Step 3 is repeated until all rows are exhausted and thus everything has been added.

Regards,
Marco