ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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
Feuerball

My solution:


Bulien
davidskaife
Magnetar

My attempt, not very simple but it works!

 

 

Dominic_Brady
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
Asteroid

my solution attached

SteveY02
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
Asteroid

Calculated only linear distance, no dataset for drive length.

pedcar
Asteroid

solution without drivetime

RebekaMazuchova
Asteroid

:)

Daniel_Homola
Asteroid

Here!

Rhys_Cooper
Bolide

Great refresher on spatial tools:

 

Spoiler
Screenshot 2025-06-06 091137.png