This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
A solution to last week’s challenge can be found here.
Weekly challenges are a great way to experiment with some tools in Designer that you don't normally get to use. They are also a great way to experiment with new methods of solving when you check out the ways other people solved the same challenge. Everyone has their favorite tools and it's easy to have a go-to method when presented with a given challenge.
This week, the challenge is to use some mental flexibility while solving. The dataset provided has x,y coordinates for our Irvine and Broomfield offices. Your challenge is to find 3 different ways of solving the problem: Find the x,y coordinates of the point that lies exactly in the middle of these two offices.
Really Fun challenge. Exited to see others approach.
Cheers and Happy Analyzing : )
Excited to see all the ways to solve this problem!
I could only see how to do this with averaging the points with the summation tool. Looking at the other posted solutions I have now learnt a lot more about spatial objects.
This was a very fun challenge to go through!
Although I think my solutions #1 and '2 are very similar... so I will be looking through what others did and see what other approaches are there 🙂
#1 - create points, use summarize to combine two rows, then use spatial info to get the centroid
#2 - similar to the above but use poly build to create a poly line instead, then use spatial info to get the centroid
#3 - reshape the data to have locations as separate columns, find the average for long and lat, reshape the data again for locations to go down the rows and create points