Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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

ainderike
8 - Asteroid

It's a share I don't have a license to calculate the drive time...

Spoiler
ainderike_0-1638614297080.png

 

Anmol97
8 - Asteroid

Here's my solution

Abhishekanand97
7 - Meteor

Here's mine.

fimler
8 - Asteroid

Here is my solution.  I got the same answer as the provided solution I just got there a different way.  

Spoiler
fimler_1-1638730688273.png

 


 

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT Solution 26.png

VictorCruz
Alteryx
Alteryx

Solution using 2 tools.

THanks!

Victor Cruz
Sales Engineer, LATAM
Alteryx
asmehta4
5 - Atom

Got the job done. Grouped by Date on the Cross-Tab...before that though, I needed all the locations with the same name (Start, Worksite, End Hotel to be in the one field/column, so I used a couple formula tools. Probably not the formulas other people used, but they got the job done. 

 

asmehta4_0-1639693647174.png

 

r_manju02
8 - Asteroid

Here is my solution

bhatt007
8 - Asteroid

Hi,

 

Please find my solution.

 

 

Thanks

Himanshu Bhatt

AndrewSu
Alteryx Alumni (Retired)

my take 🙂 drivetime distance is a bit different, but i imagine it's because of the updated datasets.