Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

RWvanLeeuwen
11 - Bolide

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

Here's my solution. 

Lily_Unsworth
8 - Asteroid
 
spriya17
7 - Meteor

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

 

Spoiler
Challenge 26.PNG
Zachary
7 - Meteor

using poly-build

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

TimothyManning
8 - Asteroid
Spoiler
26. Spatial.PNG
joshuaburkhow
ACE Emeritus
ACE Emeritus

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!

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
EricWe
Alteryx
Alteryx
 
Hannah_Lissaman
11 - Bolide

My solution :)

Ns89
6 - Meteoroid

Nice simple solution that I built:Chal26.JPG