Identify most popular/frequented route

Hi there,

I have got a case, and a bit unsure how to proceed. The case is as follws:

In the city there are different locations where public bikes are stationed, and I want to identify and vizualize which station is the most popular/frequented, and to which station they end their trip. (5 most frequented routes). In addition, I want to identyfy the rush-hour to the different stations, as well as which day of the week that is most popular.

I have attached a sample of the data below 🙂

Thanks in advance

Bicycle-routes.yxdb

Spatial Analysis

Accepted answers

afv2688

There you go, should be able to open it now.

you can open the workflow on a notepad and edit the second line:

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2019.1">

Change it to your current alteryx version. This should help you.

Regards

bycicles.yxmd

All comments

LukeG

Hey @olehr,

Here is an example of how this process could be started. I created a workflow that shows us our top 5 routes taken, and it uses the Latitude/Longitude to create spatial points.

With this start, you can now begin digging further into rush hour, day of week, etc.

Let me know if you have any questions!

Luke

Workflow Example.yxmd

olehr

Hi @LukeG,

Thank you for this 🙂 just on question. Does it now take into account which station people start at, and at wchich station they end?

afv2688

Hello @olehr ,

Here you go

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

bycicles.yxzp

olehr

Hello @afv2688

Thanks for responding. Unfortunately I cannot open the bicycles.yxzp as I have an older version of Alteryx.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703