Hi everyone!
I hope you're all doing well.
I'm working with historical trip data from a bike-sharing app and I'm trying to identify the most popular routes between stations.
The dataset includes the following relevant fields:
- start_station_name
- end_station_name
I’d like to calculate the number of trips for each unique combination of start and end station, so I can determine which routes are used most frequently.
What would be the best way to approach this?
Thanks in advance for your help!
SQL Example:
On SQL I was able to perform the calculations like this:What I've been able to achieve in Tableau:
I got something going on Tableau, but I haven't been able to find a way to sort the results without them being grouped by start_station_name. I want to see the overall rank, no the rank by start station if you get my meaning, practically the same way as the SQL results.
you can create a combined field as (start station + end station) and use it instead of the 2 fields
