1. Combining characteristic and quick table calculations
OK, what we want to do now is rank the stations by using table calculations, and then combine three characteristics to tell as much of the data story as we can. Then we will see how to add visualizations to tooltips!
So let's build the map again by adding longitude
And latitude
And then From Station Name to tooltips.
Let's keep the map normal this time but still add streets and highways, and let's add cities on top of it.
Now to our characteristics. We want to have a station rank, total hours traveled, and how many trips were taken.
So let's drag Trip Duration in hours to Color: the darker the blue the higher the cumulative time on bikes out of that location.
Let's bring the opacity to 80%.
And let's add a gentle edging.
Then we drag our count of trips to Size: the bigger the circle the higher the volume of activity at that station.
Now to stations ranking. Let's add a filter for count of trips and add a quick table calculation with ranking.
Now we can show the filter, which allows us to focus on the top 20 stations with the highest volume of activity.
Now let's make sure each one of our three characteristics are accessible in the tooltips, by pressing Control and dragging the fields to tooltips. Now this is what our tooltips look like.
Let's edit them the tooltips to polish the presentation,
We don't need the latitude and longitude information,
Let's put the station name on top,
Followed by the station rank, (Station Rank #)
Then hours traveled, (Hours Traveled)
And then how many trips were taken (trips taken at the end).
And clean up.
Make the station name Size 12 and blue,
Make it all Tableau Bold
And center.
Let's take a look at how the tooltips render!
It seems this station station is the number one station, based on its size and color, and the tooltips confirm it with about 14,000 hours out of there and about 21,000 trips taken from that location.
And there we have it, we can look at our top performers and understand their activity at a glance based on size and color, and get some more detail by hovering over each station.
Depending on your assessment of the viz you can make the circles a bit bigger and the edges a bit darker if you want to.
Now, let's see how to add visualizations to the tooltips. We create new worksheet,
rename it to Timeblock Bar Chart.
We add From Station Name,
count of trips,
and Time Block to the sheet.
Let's get the percent of total for the count of trips,
And let's build a bar chart.
Let's show the marks labels, and let's hide the header for the station names, as the station name will already be in the tooltips.
Now we go back to our previous sheet,
edit our tooltips,
Click insert, then Sheets, and select the Sheet we just built. We could change the maximum height and width if we wanted to, but we will keep the default values.
Click OK,
And now if we hover over a tooltip, we have the bar chart in there, and the detail of the station usage by time block.
OK, your turn to have fun!
2. Let's practice!