Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
alteryx Community

# 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.

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

17 - Castor

Challenge Completed

11 - Bolide

My resulting image:

Spoiler
I thought I may as well use a Mount Everest-like icon for this walking challenge

My workflow:

Spoiler
Using 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 (:
7 - 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
11 - Bolide

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

Spoiler
Moderator

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

8 - Asteroid

My solution attached.

8 - Asteroid

completed

Alteryx Alumni (Retired)

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.

17 - Castor

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

Here's the tracking chart for our participants:

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

13 - Pulsar

@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.