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

bbaker
7 - Meteor

Distance Calculated!

 

Spoiler
bbaker_0-1594152447131.png

 

FlorianC
Alteryx
Alteryx

The drive distance will vary depending on the vintage of the data package used but this is a great example on how the spatial tools can be utilised.

 

Spoiler
WorkflowWorkflow
Florian Carrier
Strategic Solution Consultant
Alteryx
DN
8 - Asteroid
Spoiler
chal26.PNG

This is my solution. However, I really like the elegant solution that @LordNeilLord gave.

jfeldkamp123
8 - Asteroid

Good basic case to find the distance between pts and add them up for daily aggregate.

Zach_Soluryx
6 - Meteoroid

I've used Cross tab and Transpose.

Well, probably not the most efficient solution, but it works. 

Here is my Workflow : 

Spoiler
Capture_Workflow.PNG
LittleE
8 - Asteroid

My solution:

Spoiler
LittleE_0-1594760681513.png

 

ehughes
9 - Comet

My solution

Spoiler
Img 26.PNG

matt_un
7 - Meteor
Spoiler
matt_un_0-1595510426399.png

 

JoePC
9 - Comet

Solution Attached

bmcclelland46
10 - Fireball

Maybe could have used a tool or two less but still a good time!

 

Spoiler
bmcclelland46_0-1595962610380.png