5 Replies Latest reply on Feb 2, 2017 11:13 AM by Joseph Hobbs

    Route direction using color (Tableau 10)

    Joseph Hobbs

      Hello Community,

       

      Generally, I'm looking for improvements to this proof-of-concept visual I'm making. Specifically, I want to show the direction of travel along a route by going from light blue to dark blue.

       

      This map has 3 goals:

       

      • Show freight lanes that we placed a bid on and how many shipments our clients said would be there.
      • Show actual freight and revenue data along those same lanes to see if we got as many shipments as the bid file said was there
      • Show which terminals we want the freight to go through (with a simple R/Y/G coding)

       

      To do this though, I need to show which direction the freight is traveling. I've tried layering in arrows via Alteryx, but it doesn't suit my needs because I can't do use a dual-axis to show terminals then.

        • 1. Re: Route direction using color (Tableau 10)
          Jim Dehner

          See the attached - I changed your NEED to get to color directly

          then changed the LON2 tile to line and placed need onto color and made it a line

           

           

           

          IF [% Inbound] <= .4 THEN "Red"

          ELSEIF  [% Inbound] <= .50 THEN "Yellow"

          ELSE "Green"

          END

           

           

          Will this work for you

          Please let me know

          Jim

          • 2. Re: Route direction using color (Tableau 10)
            Joseph Hobbs

            No, unfortunately, it doesn't. For instance, is this freight going from Washington to Texas or from Texas to Washington?

             

            This is included in the Origin/Destination (O/D) Dimension but I've not found a food way to incorporate it.

             

            However, if I use Need to determine color, I might be able to color-code the terminal dots based on Origin/Destination.

            • 3. Re: Route direction using color (Tableau 10)
              Jim Dehner

              1- I'm not certain what you want - I looked at your viz and could not determine direction - and to really understand what you were trying to achieve

               

              2 - If you go to the LON2 tab and make the chat type dots That's exactly what it will do - When I first made the chat the terminals showed up in color - I thought you wanted the lines in color

               

              Jim

              • 4. Re: Route direction using color (Tableau 10)
                Joseph Hobbs

                Sorry for the confusion. The post mentions route direction as does my first paragraph, so I assumed we were on the same page.

                 

                Tableau's instructions on maps involve making two rows that represent a line between an origin and destination. So here's Tableau's suggested data setup:

                Origin-DestinationStationPath IDLatitudeLongitude
                OriginBT-01BT-01_BT-0147.61841-122.35101
                DestinationBT-01BT-01_BT-0147.61841-122.35101

                 

                And here is mine:

                 

                   

                O/DTerminalLane ID
                Destination642859-642
                Origin859859-642
                Destination859890-859
                Origin890890-859

                 

                I then map the Terminal ID to a Lat/Lon.

                 

                So, my primary goal is not to color the lines (I can do that) but instead to show which direction freight is traveling (from Origin Terminal to Destination Terminal)

                 

                My Secondary goal is to have the dual axis show favorable terminals through Red/Yellow/Green coding.

                 

                Does that help clarify?

                • 5. Re: Route direction using color (Tableau 10)
                  Joseph Hobbs

                  So, instead of using color, I found a forum post here where they managed to get direction based off an Origin/Destination dimension. I think that solved my problem!