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.
alteryx Community

# Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

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

Submit Feedback

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

13 - Pulsar

@RWvanLeeuwen I like the custom start/end icons!

Ha ha, in the real version of this report, I did include participants with zero miles, mostly so I'd be prompted to remind them to update their data entry!

15 - Aurora

Challenge 166 is done!

Spoiler
13 - Pulsar

My solution:

Spoiler
8 - Asteroid

Some good practice with the reporting tools.

8 - Asteroid

Solution attached.

Spoiler
15 - Aurora

Go team!

Spoiler

9 - Comet
Spoiler
7 - Meteor

Solution attached.

8 - Asteroid

Struggled with this one, since I don't know the map tools at all.  Learned a good bit though, especially about labelling

Spoiler
Process:
- Create spatial points from lat and long
- Sort so that start and end points are in correct order (to end in Nashville)
- Make subsequent points the end points for each segment (bringing start and end to same record)
- Create line between start and end points
- Measure distance between points
- A couple of tools that may not be necessary (skipping here in description)
- Add running total of distance
- Calculate running total of distance 'travelled'
- Summarize tool to determine max distance for each participant
- Join with Participant List (join on Name)
- Union to capture Participant 5 since not in activity log
- Set MaxRun to 0 if null (might not be necessary)
- Sort MaxRun (asc)
- Append records with spatial points (since I couldn't find any way to join them given that map distances not equal to MaxRun distances
- Set Marker flag if MaxRun distance less than or equal to each map point distance
- Filter out records with null Markers
- Select first record for each Name (these will be the points that match the MaxRun total to the map) - that will be flagged on map
Feed forward to Report Map tool
- #1: Participant data
- #2: Map data
- #3: StartPoint data for initial marker (House)
- #4: EndPoint data for final marker (Star)
Report Map tool....
- Set each feed item as data for map (this was the part I struggled with until I figured out that different layers needed different threads feeding in - perhaps I should have read up on how to use the tool.... naaaah, that couldn't be it)
- Create layer for each tool and select format options

8 - Asteroid