where:
Route – name of the bus route.
Sequence – details the order of the bus stops on the route (e.g. Route 1 starts at New Oxford Street and next stops in Museum Street).
Start Stop/End stop – the start and end stop for each sequence on each route.
Start/End Longitude and Latitude – Geographic points for the start/end stop.
However, sometimes you may find a data-set like the following:
In which case, you need to prepare the data to include the end stop variables in each row (as before in the first example). You can do this in preparation software, but there’s also a neat little trick for doing it in Tableau:
1) Click and Drag your data-set, and place it next to itself to create a join.
Now we can create a new sheet, and make our lines.
In order to create the lines for each route, we first need to create the points for each stop. This is where the new functions come in. Create 2 new calculated fields, for the
start
and
end
stops for each of the sequences on each route. Use the Makepoint function, entering the Lat and Long values into the parentheses (in that order!).
