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.

SUBMIT YOUR IDEA

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

Christina_H
14 - Magnetar

My solution

Spoiler
image.pngimage.png
geoff_zath
Alteryx
Alteryx

Workflow

Spoiler
challenge_166_workflow.png

Map

Spoiler

challenge_166_map.png

 

asultanov
8 - Asteroid
Spoiler
Screenshot 2024-02-06 120255.png
Rob-Silk
8 - Asteroid

Solution attached below:

 

Spoiler
challenge_166a_RS_screencap.PNGchallenge_166b_RS_screencap.PNG
lynnesonneyrsm
8 - Asteroid

I loved the mix of spatial and reporting here! helped me learn some of the cool feature of the report map tool as well 

Bren_Spill
12 - Quasar
Spoiler
image.png
Erin
9 - Comet

I took a different (shorter) route to calculate the closest node per participant. 

Spoiler
I did a running total of the distance between nodes, and stacked that with the sum of participant miles. Then I used a multi-row formula to bring back the route node from the previous row (closest node but not farther than sum miles)
challenge 166 - wf.png

challenge 166 - map.png

Erin
9 - Comet

Woops, forgot something!

 

Spoiler
Pesky participant 5 forgot to walk/run/bike, and I forgot to include him/her! My bad! Updated workflow attached.
Bobbyt23
8 - Asteroid

Great challenge. Loads of tools to use. Had to get a bit of help with the report map as never really used that much before.