Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #166: I'm Gonna Be (500 Miles) - at Inspire

JoeM
Alteryx Alumni (Retired)

OK, OK, maybe it's just short of 500 miles (448 to be exact), but it shouldn't stop you from listening to the Proclaimers while solving this week's challenge!

 

This week we have an awesome submission from @kelly_gilbert! In the words of Kelly:

 

Leading up to Alteryx Inspire 2019, a few of my colleagues and I are doing a walking challenge. We are (virtually) walking 448 miles along the Natchez Trace Parkway (https://www.nps.gov/natr/index.htm) from Natchez, MS, to Nashville, TN. The goal is to walk, run, bike, etc. ~3 miles per day (starting in January) to make it to Nashville in time for Inspire! I wanted to show our progress by displaying our current positions along the route.

 

Goal: create a map that contains
1) A line showing the route
2) Points identifying the start and end of the route
3) Points showing the current location of each participant. The participant's location is the node that is closest to (but not farther than) the number of miles they have completed.

* natchez_trace_coordinates.yxdb contains the lat/lon of points along the route
* Participant List contains information about the participants
* Activity Log contains the daily miles for each participant

 

Node coordinate data © OpenStreetMap contributors (https://www.openstreetmap.org/), and route generated using OSRM (http://project-osrm.org/). Both data sources are made available under the Open Database License: http://opendatacommons.org/licenses/odbl/1.0/. Any rights in individual contents of the database are licensed under the Database Contents License: http://opendatacommons.org/licenses/dbcl/1.0/

RichoBsJ
11 - Bolide

Hi! Here my solution :)

 

Spoiler
Captura166.PNG

 

NicoleJohnson
ACE Emeritus
ACE Emeritus

My solution! 

 

Spoiler
Had fun figuring out how to deal with multiple participants being at the same node at the same time, since Participant 1 and Participant 7 appear to be battling it out at the finish line...Had fun figuring out how to deal with multiple participants being at the same node at the same time, since Participant 1 and Participant 7 appear to be battling it out at the finish line...Took me a while to remember where to find where to update icons in the Map reporting tool... but once I found it, I was pleasantly reminded of the great built in options for customizing maps!Took me a while to remember where to find where to update icons in the Map reporting tool... but once I found it, I was pleasantly reminded of the great built in options for customizing maps!

I have a bit further to walk to get to Nashville from the Seattle area... about 2,400 miles on foot, which Google maps (quite unrealistically) estimates will take me approximately 780 hours to traverse... so that means I should have started walking about 20 days ago. Or at my preferred walking speed, more like 20 weeks ago. Oops.

 

Guess I'll fly there after all. :)

 

Cheers,

NJ

Kenda
16 - Nebula
16 - Nebula

 

Spoiler
Whenever I hear this song, I can't help but think of How I Met Your Mother!
giphy (1).gif


Fun challenge! I'm getting all of the correct miles to date for each participant but can't get the node to match the given output. I can't seem to find where my logic would be wrong, though..
Looking forward to seeing other solutions to check if I'm just missing something
Capture.PNG


2.PNG

 

 

kelsey_kincaid
12 - Quasar
12 - Quasar

My solution is below. I can see that my participants' positions are a little bit off based on the expected output, and I'm fairly certain it has something to do with the way I calculated distance along the path. I'm just getting my start with spatial tools so this was a great challenge! I'm sure my workflow could use a lot of work, so I'm excited to see what everyone else builds!

 

Spoiler
KA-166.PNG166 map.PNG
bdaniels
8 - Asteroid

My Solution Attached!

 

Spoiler
Screen Shot 2019-05-28 at 1.51.05 PM.png
Never done a lot of work with the Map Render tool, good stuff!
Screen Shot 2019-05-28 at 1.44.10 PM.png

patrick_digan
17 - Castor
17 - Castor
Spoiler
Capture.PNGCapture2.PNG
cgoodman3
14 - Magnetar
14 - Magnetar

I love how easy spatial problems are to solve in Alteryx!

Spoiler
Challenge 166.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
shaynie
8 - Asteroid

My first weekly challenge!

Couldn't figure out how to set the font, and look forward to seeing how it's done!

T_Willins
14 - Magnetar
14 - Magnetar

If you're going to have a map and data output, gotta use Visualytics!

 

Spoiler
Workflow 166.GIF

 

Results 166.GIF