Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAManaged 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