Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #184: Closest Pubs to Tobacco Dock

justindavis
10 - Fireball
Spoiler
challenge_184_solution_justindavis.PNG
kelly_gilbert
13 - Pulsar

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

 

 

 

Flo_G
7 - Meteor

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!

 

 

cplewis90
13 - Pulsar
13 - Pulsar

Didn't realize I never published my solution. 

Spoiler
Challenge 184 - output.PNG
NicholasM
Alteryx Alumni (Retired)
Spoiler
Capture.PNG
Wouter
8 - Asteroid

My solution:

Spoiler
challenge 184.JPG
NicoleJohnson
ACE Emeritus
ACE Emeritus

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 

dombaikamilla
8 - Asteroid
Spoiler
184.PNG
LiD
8 - Asteroid
Spoiler
LiD_0-1573247552448.png
SimonSturges
7 - Meteor

Took longer than expected but got there in the end. 

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