Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution. Once again the weekly challenge was an opportunity to practise tools, I rarely use in daily business.

 

Spoiler
workflow.png

map.png

Highlighted
8 - Asteroid

Nice challenge... learned a new tool!

 

Spoiler
challenge_166_map.jpg
Highlighted
17 - Castor
17 - Castor

Excellent Challenge.  I got to hone my report map making skills.  

 

Progress.png

 

Spoiler
For the first time, I find myself in the situation where I used an iterative macro and almost everyone else used Append fields to find the closest node.  Normally the situation is reversed.  Ah well...same nail, different hammer.

MainMain

MacroMacro

 

 

Dan

Highlighted
14 - Magnetar
14 - Magnetar

As with @NicoleJohnson , I am too late to begin my trek from NY, so I'll have to take to the skies. Can't wait to meet you in Nashville!! 

Spoiler
image.pngimage.png

 

Highlighted
11 - Bolide

Wow, this is why Weekly Challenges are awesome... I'm learning so much from everyone else's submissions (and I'm the one who made up the challenge!)

 

@NicoleJohnson  - I might shamelessly steal your labeling idea for my "production" version of the challenge tracker... I have been jittering the markers for participants that are nearly tied, but I have been handling overlapping labels by manually adjusting the label position.

 

@kayers  - way to jump into spatial! If you haven't already, check out the interactive lessons. I found them super helpful when I was getting started with spatial!

 

@cgoodman3 - I like how you labeled the connectors going into the map tool! I recently found that feature by accident, and this is a perfect use case. I'm totally going to add this to my "production" workflow!

 

@shaynie - welcome to Weekly Challenges! Warning: they're addictive... I definitely had to do a lot of trial and error on the label formatting, and I'm hoping to learn some new tricks from others, too!

For those of you who are getting different distances, here is a hint:

Spoiler
The solution uses the distance along the path, rather than the straight distance from the starting point.

challenge_166_hint.png
Highlighted
12 - Quasar
12 - Quasar

Here is my solution! Loved listening to this song while jamming out! Even made a Pandora station to get all the similar songs!

Spoiler
I actually took a different approach from the other submissions. I created a macro that creates a line to each point (including all points leading up to each point) and then calculated the distance to each node. I then looked at those distances to compare to where each person would fall on the line. It also matched back to the desired output.
Challenge 166.PNGChallenge 166 - macro.PNG

I also spent way too much time making my chart look better (still not the best it could be)
Challenge 166 - map.PNG

 

Highlighted
Alteryx Community Team
Alteryx Community Team

@cplewis90 that's the spirit! Also, who knew The Proclaimers were twins?!

Highlighted
Alteryx
Alteryx

My solution:

 

Spoiler
Flow.PNGMap.PNG
Highlighted
12 - Quasar
12 - Quasar

@JoeM I had no idea until now! Learn something new everyday!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

 

Spoiler
This is as close as I could get the map without spending too much time on it. 
Challenge_0166-CharlieS_Solution.png