community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

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

Alteryx Certified Partner

Challenge Completed

Alteryx Certified Partner

My resulting image:

Spoiler
166 image result.pngI thought I may as well use a Mount Everest-like icon for this walking challenge

My workflow:

Spoiler
166 workflow.pngUsing formula tools for spatial data is quite useful

Notes:

Spoiler
I intentionally did not plot participant 5 as that person has not walked at all. First generate some data by walking the walk and then you may do the talk (:
Meteor

 

Nice to tackle a spatial challenge as I don't really use these tools often! can't work out how my text went green though - it is set to black in the config!?

 

Spoiler
166.PNG
Bolide

I added a line graph to track the participant progress as well. 

Chart.JPG

Spoiler
workflow.JPGmap.JPG
Moderator
Moderator

Not as pretty or well labeled as some of the others, but it's complete.

Asteroid

My solution attached.

Alteryx Partner

completed

Alteryx
Alteryx

I really enjoy the spatial exercises. Spent way more time on this than I probably should have, mostly playing with the Report Map tool. Also I added a date filter with a Map interface tool so I could watch the progress of the participants.

Nebula
Nebula

When you think about it - 500 miles is a long way to walk for someone...

500Miles.jpg

 

Here's the tracking chart for our participants:

 

 

 

SolutionMap.png

 

 

 

Spoiler

Here's the solution:
- This relies on ordering the points in the route; then doing a distance check between each two; then doing a running total (i.e. the distance of each point from the start along the route)
- Then cross-join all the participants against all the points (with their distances)
- Then find the closest one point to that distance

FlowPic.png

 

 

Fireball

@shnbrb - it's pretty weird that the default map label is green text with a thick black outline! That's definitely the first thing I change when I make a map. To change it, just set the text color to black (or whatever you like). You can also remove the outline (if desired) by setting the size to zero.

clipboard_image_0.png