The Weekly Challenge Program is evolving! We’re creating a better, more modern experience designed around how our community learns and practices today, with a refreshed program launching soon. Stay tuned!
Start Free Trial

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

DylanBell
10 - Fireball

My solution:


Bulien
davidskaife
14 - Magnetar

My attempt, not very simple but it works!

 

 

Dominic_Brady
8 - Asteroid

My solution: used multi row formula to generate stop ID's for the journey each day, which I then built a sequence polyline from and subsequently measured.

JBevan89
8 - Asteroid

my solution attached

SteveY02
8 - Asteroid

Almost Done.

Unlike other user, I used self-join and distance tool to calculate the straight line distance. To me, this method is more straight forward the cursive calculation.

One more thing, I don't have Spatial Data Pack, So don't know how to calcaulate the drive distance, maybe google map api could be a option?

TGreen
8 - Asteroid

Calculated only linear distance, no dataset for drive length.

pedcar
8 - Asteroid

solution without drivetime

RebekaMazuchova
8 - Asteroid

:)

Daniel_Homola
8 - Asteroid

Here!

Rhys_Cooper
11 - Bolide

Great refresher on spatial tools:

 

Spoiler
Screenshot 2025-06-06 091137.png