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 FeedbackManaged to get the straight line distance. I don't think I have the facilities to get the drive distance though
Solution for straight line distance
Like the original solution.
Unfortunately cannot actually complete the challenge due to missing drive time data files (which I cannot seem to get). However, I know the approach..
Solved!
I could think of 2 solutions at least.
But most of the time I actually spend understanding the challenge 😏 If-Drive Distance output confused me a lot.
1. using Poli-Build with Sequence-Polyline
2. Multi-row formula and cross-tab