Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

belalmos
7 - Meteor

Thanks for the challenge ,My Solution

Ben_Jeffreys
8 - Asteroid

My submission

steven4320555
8 - Asteroid

This one is straight forward.

(Edit: Just realised that my solution is simpler compared with many others, as I have used spatial function, thanks to the input data is already a spatial type.)

 

Spoiler
steven4320555_0-1586794732071.png

 

 

Shelbey
Alteryx
Alteryx

I was only able to get the straight-line distance.

joshvbarth
8 - Asteroid
Spoiler
joshvbarth_0-1586968820984.png

 

freewind
7 - Meteor

straight line only

For drive distance, do I need to prepare data myself by drawing?

seinchyiwoo
Alteryx Alumni (Retired)

using the distance function in multirow formula instead.

Spoiler
seinchyiwoo_0-1587351869646.png

 

deepaprash
8 - Asteroid

Done

Zangoly
8 - Asteroid

I was initially trying to create a new column that has the 'spatial' data type but i did not know how so i had to use the solution, which went down a different route which I still don't fully understand how it worked.

Spoiler
Zangoly_0-1587478910335.png

 

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !