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 Partner

Thanks for the challenge ,My Solution

Highlighted
8 - Asteroid

My submission

Highlighted
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

 

 

Highlighted
7 - Meteor

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

Highlighted
Alteryx Certified Partner
Spoiler
joshvbarth_0-1586968820984.png

 

Highlighted
7 - Meteor

straight line only

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

Highlighted
Alteryx
Alteryx

using the distance function in multirow formula instead.

Spoiler
seinchyiwoo_0-1587351869646.png

 

Highlighted
8 - Asteroid

Done

Highlighted
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

 

Highlighted
Alteryx Certified Partner

Here is my solution !