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
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
7 - Meteor

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

 

Spoiler
Challenge 26.PNG
Highlighted
7 - Meteor

using poly-build

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

Highlighted
Alteryx Partner
Spoiler
26. Spatial.PNG
Highlighted
Alteryx Partner
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 🙂

Highlighted
6 - Meteoroid

Nice simple solution that I built:Chal26.JPG