We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.
alteryx Community

# 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.

## Challenge #242: Meet Me Halfway

Alteryx

A solution to last week's challenge can be found here

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.

15 - Aurora

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

17 - Castor
Spoiler

12 - Quasar
Spoiler
11 - Bolide

So many beautiful cities & regions to visit!

Spoiler

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

Spoiler

11 - Bolide

Spoiler

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.

7 - Meteor
Spoiler

12 - Quasar

Fun spatial challenge!

Spoiler
11 - Bolide
Spoiler

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

9 - Comet

Great challenge to start the week!

Spoiler

Spoiler
Did anyone else notice that the point created for Broomfield is in California?