7 Replies Latest reply on Nov 7, 2018 5:43 AM by Ken Flerlage

    Creating a destination map as a Sankey graph?

    Rafael Benavent

      I have data like this:

       

      Trip ID | Origin-Destination | Stop Name       | Card Type

      1          | Origin                    | Central Station | Adult

      1          | Destination            | North Station    | Adult

      2          | Origin                    | Main Street       | Student

      2          | Destination            | West Street      | Student

      etc.

      I've attached a sample data file.

       

      What I would like to do is calculate the top 10 stops by origin by card type and calculate the top 10 stops by destination by card type.

      Then I would like to create a Sankey graph with the left column the top 10 stops by origin, and on the left, the top 10 stops by destination.

      Each line of the Sankey should be colored based on card type (eg. blue for adult, green for student).

       

      I've managed to get a Sankey done following this tutorial but I can't seem to be able to get it to show the data I want (that is, going from top 10 stops by origin to top 10 stops by destination).

       

      Any help would be greatly appreciated.