Weekly Challenge

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

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

Submit Feedback
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.

Challenge #242: Meet Me Halfway

Highlighted
Alteryx
Alteryx

A solution to last week's challenge can be found here242image.png

 

One day it will be nice to travel again. When that day comes, efficiency won't be on many people's minds, but we can dream...

 

This week's challenge is to find the most central office location to meet up, given a list of cities in which Alteryx has offices. The dataset contains the City, Region, and coordinates of the cities. Your task is to determine the city that is most central for each region, then calculate the distance from each of the other cities in that region to that city.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge 242 is done! The sort was only to get records in the exact order as the challenge output so technically managed a 4 tool solution!

 

Spoiler
Jonathan-Sherman_0-1605537472762.png

 


 

 

Highlighted
16 - Nebula
16 - Nebula
Spoiler
patrick_digan_0-1605535102464.png

 

Highlighted
12 - Quasar
Spoiler
Screenshot 2020-11-16 090107.png
Highlighted
Alteryx Certified Partner

So many beautiful cities & regions to visit!

Spoiler
242.2.PNG

(edit 11/16 10:00 CT) video of solution overview:

Spoiler

 

Highlighted
Alteryx Partner

 

Spoiler
dsmdavid_0-1605536130211.png
Was trying to plot a map, but got an error:
\AppData\Local\Alteryx\bin\RuntimeData\MapServer/Default.map: MapServerError - Routine:msProcessProjection() Message:proj error "no system list, errno: 2
" for "init=epsg:900913" Code:11 ??

oh well, just the table then.

Highlighted
7 - Meteor
Spoiler
Capture.PNG

Highlighted
Alteryx Certified Partner

Fun spatial challenge!

 

Spoiler
wc242.png
Highlighted
11 - Bolide
Spoiler
PaulFound_0-1605538022115.png

 

Wow, wasn't expecting that to be that simple! Good job Alteryx!

Highlighted
8 - Asteroid

Great challenge to start the week!

 

Spoiler
challenge_242_solution-DeanWest_snippet.png

 

Spoiler
Did anyone else notice that the point created for Broomfield is in California?
challenge_242_solution-DeanWest_snippet-2.png