Weekly Challenge

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

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

Submit Feedback
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.

Challenge #26: Service Technician Travel Distance

Highlighted
7 - Meteor

Distance Calculated!

 

Spoiler
bbaker_0-1594152447131.png

 

Highlighted
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
Highlighted
7 - Meteor
Spoiler
chal26.PNG

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

Highlighted
7 - Meteor

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

Highlighted
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
Highlighted
8 - Asteroid

My solution:

Spoiler
LittleE_0-1594760681513.png

 

Highlighted
8 - Asteroid

My solution

Spoiler
Img 26.PNG

Highlighted
7 - Meteor
Spoiler
matt_un_0-1595510426399.png

 

Highlighted
Alteryx Partner

Solution Attached

Highlighted
8 - Asteroid

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

 

Spoiler
bmcclelland46_0-1595962610380.png