Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #26: Service Technician Travel Distance

Highlighted
Alteryx Certified Partner

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
Highlighted
Alteryx Partner

Here's my solution. 

Highlighted
Alteryx Partner
 
Highlighted
Meteor

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

 

Spoiler
Challenge 26.PNG
Highlighted
Meteor

using poly-build

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

Highlighted
Alteryx Partner
Spoiler
26. Spatial.PNG
Highlighted
Alteryx Partner

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!

Highlighted
Alteryx
Alteryx
 
Highlighted
Alteryx Certified Partner

My solution :)

Meteoroid

Nice simple solution that I built:Chal26.JPG