Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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

tristank
ボリード

Time for a drink!

 

スポイラ
Screenshot 2023-12-12 175520.png
BSilverblatt
アステロイド

Thanks for the challenge! Here's my solution:

SamBreen
アステロイド

Bit of a long winded way looking at other solutions...

 

スポイラ
Challenge 184.PNG

Rob-Silk
アステロイド

Solution attached below

 

スポイラ
workflow:
challenge_184_RS_screencap.PNG

Map with all pubs within a 1km radius:
challenge_184b_RS_screencap.PNG

Map restricted to only pubs north of the river - just filter out pubs within Southwark:
challenge_184c_RS_screencap.PNG
asultanov
アステロイド
スポイラ
Screenshot 2024-02-06 164248.png
lars3033
メテオロイド

The location given for Tobacco Dock is INCORRECT.  The dock is located 0.060296 EAST longitude, NOT WEST.

 

Many people here probably didn't look carefully at their solution, as the incorrect Tobacco Dock location places it squarely on the flight line at London City Airport ><

 

Definitely not a dock ...Definitely not a dock ...

 

image.png

 

 

 

aatalai
オーロラ

C184

Erin
ボリード

The pub color differs depending which side of the river it is on  😎

 

challenge 184 - map.png

 

Workflow:

 

スポイラ
I couldn't figure out if there's a way to only show the outline of a polygon on the report map. So I split the trade area into points and then made a polyline from it. 
The pubs theme is set to borough_name so that they will have different colors based on which side of the river they're on. 
challenge 184 - wf.png

 

 

** Is it 5 pm yet??? Cheers!!! **

 

Bobbyt23
パルサー

Obviously don't know my Easts from Wests. Got there when I spotted the mistake though.

Bren_Spill2
12 - Quasar
12 - Quasar
スポイラ
image.png