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

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

 

Spoiler
workflow.png

map.png

Asteroid

Nice challenge... learned a new tool!

 

Spoiler
challenge_166_map.jpg
Aurora

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.

Main.pngMain

Macro.pngMacro

 

 

Dan

Highlighted
Pulsar

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

 

Fireball

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
Bolide

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

 

Director, Customer Enablement
Director, Customer Enablement

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

Alteryx
Alteryx

My solution:

 

Spoiler
Flow.PNGMap.PNG
Bolide

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

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