We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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
Solutions Engineer
Alteryx
dssnek
8 - Asteroid
Spoiler
chal26.PNG

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

jfeldkamp123
7 - Meteor

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