community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

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

Alteryx Certified Partner
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

 

 

@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