Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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.

SUBMIT YOUR IDEA

Challenge #26: Service Technician Travel Distance

AndrewHoData
8 - Asteroid

Managed to get the straight line distance. I don't think I have the facilities to get the drive distance though

 

Spoiler
AndrewHoData_0-1666743050234.png

 

JeroenAerts
6 - Meteoroid

Solution for straight line distance

Spoiler
JeroenAerts_0-1667210132513.png

 

TungThanhHo
8 - Asteroid

my solution

DenisZ
11 - Bolide

Here is my solution

 

Spoiler
DenisZ_0-1667466849448.png

 

dbmurray
8 - Asteroid

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

 

Spoiler
dbmurray_0-1667542173749.png

 

AaronSmatta
8 - Asteroid

Couldn't get the drive distance, but was able to get the straight-line distance

Ross_Easton
8 - Asteroid

Solved!

Spoiler
26 solved.png

saiirangam
8 - Asteroid

Challenge Completed

FinnCharlton
13 - Pulsar
Spoiler
FinnCharlton_0-1668078297690.png

 

mzajac
7 - Meteor

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.

 

 

Spoiler

1. using Poli-Build with Sequence-Polyline

2. Multi-row formula and cross-tab



mzajac_0-1668417568775.png