Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAmy solution:
my solution:
Here's my solution
Did not use the Find Nearest tool.
Did not use Summarize to create a Centroid for each region.
Did use RegEx Parse, Create Points, and Distance.
Instead I calculated the distance between each office within a region, summed them and took the origin city with the lowest value.
Results matched the Solution output.
Workflow:
Here's my solution: