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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #184: Closest Pubs to Tobacco Dock

Asteroid
Spoiler
challenge_184_solution_justindavis.PNG
Fireball

Advanced version...

 

Input form:

challenge_184_form.PNG

 

Result (if North of Thames is selected, with a 1 km radius):
challenge_184_results.PNG

 

 

Spoiler
challenge_184_workflow1.PNG

challenge_184_workflow2.PNG

 

 

 

Meteoroid

Here's my work:

Spoiler
Definitely did not realize that W coordinates mean negative longitude, thanks for teaching me this

There's an extra point in my legend, not sure where that comes from:

fguardini_0-1572268902845.png

The workflow is quite straightforward:
fguardini_1-1572268948349.png

The spatial functions are really incredible!

 

 

Bolide

Didn't realize I never published my solution. 

Spoiler
Challenge 184 - output.PNG
Alteryx
Alteryx
Spoiler
Capture.PNG
Alteryx Certified Partner

My solution:

Spoiler
challenge 184.JPG
Magnetar
Magnetar

I love spatial tools... and mostly despise building Report Maps. BUT, I'm always so pleased with myself when the OCD finally achieves victory

 

Spoiler
WeeklyChallenge184.JPG
Chose the more challenging route, and figured out a way to isolate those pubs that were North of the river by using a Map Input tool and simply drawing a line along the River Thames The better solution would probably have been to find a data source with lat/lon points for the river banks... but there was pub drinking to be done. Ain't no one got time for that. So Map Input it was...

WeeklyChallenge184Map.JPG

The final map - I chose to highlight those that ended up North of the Thames, and then grey out those that fell below the river. Took some maneuvering with the map layers, but it's a lovely looking pub crawl by the time I finished Now, if only I could have tested it out in person!!  

Cheers!!

NJ 

Alteryx Partner
Spoiler
184.PNG
Meteor
Spoiler
LiD_0-1573247552448.png

Took longer than expected but got there in the end. 

Spoiler
Screenshot_2019-11-10 15.25.06_cjqU7Z.pngsolution map.png