Layering and total dock utilization
1. Layering and total dock utilization
Alright, the goal in this screencast is to exploit several of the dataset's features to analyze utilization. We're going to use a dual axis and multiple marks cards. Let's get started, we add longitude and latitude, use a dark background, And add the streets, highways and routes layer. and move From Station Name to the tooltips. Let's create a filter for the count of trips and filter for stations that have at least 50 trips a day. Now to get started with the dual axis we move latitude to Rows a second time to get two different splits, And we make it a dual axis and end up with three marks cards. This latitude correspond to the leftmost one and Latitude 2 to the rightmost one. This is going to give us control over layering. So let's go ahead with creating distinct characteristics. For the leftmost one, our base is going to be docks. This field indicates the total number of docks in the station, and each dock can accommodate one bicycle. So we drag the docks field to color and size. We could increase the size, but 25% actually looks good. So small pale blue circles are stations with few docks and big navy blue circles are stations with a lot of docks. For the rightmost latitude, our base is going to be the count of trips, So we drag the field to color And size. We're going to edit the palette and go with the Red-Green-Gold diverging one, and make it 9 steps. reverse it, Let's also move the center to 250. Moving the center this way would usually require you to experiment with the data until you find a satisfying value. Here again we're going to keep the size as is. The idea being that the sizes for both latitude fields should be the same. Ideally we would make them slightly bigger, like 33%, but the only way to set an exact value is to use the predefined cursors at 25 or 50%, and 50% is too big, which is why we use the default 25% size in this viz. We're going to show the mark labels and match the mark color so the label matches the interior color So when the count of trips is low we will see a small green circle, and when the count of trips is high we will see a big red circle. Notice we could decide to show only the Min and Max values, or to show all the labels by overlapping the other marks. Let's not do that as we want some enough information without crowding the viz. Now all that's left to do is put all of this in motion and make sure our bubble size overlap is in good shape. This is basically a utilization model and if the trips count bubble sizes are bigger than the docks one, it means that the station is understocked. Let's filter by week number this time, and bring it to Pages. From the Pages shelf we can change or filter, and use days instead of weeks if we want to. So now we have the information day after day. What we basically see here is that as we progress towards the summer season and the weather gets warmer, activity increases, especially on the coast line. We're also able to see which stations can potentially be overwhelmed, understand how the network is doing on capacity, and which stations could potentially get some docks added.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.