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

RWvanLeeuwen
11 - Bolide

solution was fairly simple if you do not have drivetime data available:

Spoiler
build polyline + spatial info
26.png

 

 

alternative solution that may be extended to include driving routes:

Spoiler
1) use multi-row formula to get the spatialobject from the previous row
2) get distance between two points
3) aggregate distances per day
nataliamiteva
8 - Asteroid

Here's my solution. 

Lily_Unsworth
8 - Asteroid
 
spriya17
7 - Meteor

Used multi-row tool to calculate start and end spatial object for each row (trip).

 

Spoiler
Challenge 26.PNG
Zachary
7 - Meteor

using poly-build

missing drive-time dataset - how do I get that?

TimothyManning
8 - Asteroid
Spoiler
26. Spatial.PNG
joshuaburkhow
ACE Emeritus
ACE Emeritus

I did this a little simpler than the solution. I'll give a hint: Group By on one of the tools will save you a couple tools!

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
EricWe
Alteryx
Alteryx
 
Hannah_Lissaman
11 - Bolide

My solution :)

Ns89
6 - Meteoroid

Nice simple solution that I built:Chal26.JPG