Despite my jealousy of your trip...I'm still prepared to help
So I've moved a few pills around putting your Path Order onto the Path tile...but the real issue was just how you'd set up the "Pages Filter"
I've added History and removed the fade...so the previous trip remains.
I also set up this labeling calculation...
IF [Travel Order] = 1 AND [Path Order] = 1 THEN[City]
ELSEIF [Origin-Destination] = 'Destination' THEN [City] END
so this just marks the destination as you reach them...but defaults to show both for the 1st journey.
Looks quite good (IMHO!)
I did a similar thing myself (no with the pages thing...wish I'd thought of that!). I ended up doing a Think Data Thursday explaining how i built it, so you might find that useful too.
Link to the Video and Workbook are in the post....and he's my original Indian AdVIZture! Workbook: Our India Advizture
Hope that helps.
Cuba Travels.twbx 81.1 KB
Okay! I see how you did that. :-)
I tried to edit the data so that I only visualized travel in Cuba because the map looked lame.
When I get ride of the US records and change the Travel Order dimension to a clean 1,2,3 it no longer works.
I'm really trying to understand how Tableau is interpreting data so my question is, why doesn't Tableau draw the line as I click through destinations 1-4?
It seems that the Travel Order having two records was the key.
Would you mind taking a look?
1 of 1 people found this helpful
So the problem here is that on the Travel Order, there is only one row for each leg of the travel. The "Pages" shelf is just a filter (but one that you can get Tableau to toggle through the options). This means when you say are filtered on Travel Order 2, it only has that point (so no other point to draw it to or from
In your previous version, you have both the origin and destination on each Travel Order, so when 2 is selected the data is filtered to Florida and La-Habana (rows) and the point order (1 and 2) so creates 2 points and draws the line between them
So I think you just need to create 2 rows for each one, and duplicate (even if the location is the same) where it is an origin or destination (in your first data you had a row for Fort Lauderdale, when you arrived there from Michigan, and then repeated this (Fort Lauderdale) row again, when it was used as an origin for the next part of the trip to Havana...)
Hope that makes sense
how do you get the latitude or longitude data into your original dataset?