Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

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 #15: Warehouse Shipped Miles

AJauniskis
Astéroïde

My solution: 

 

Révélation
workflow.JPG
kexelby
Météore

My solution to this weeks challenge! 

sprodger
Astéroïde

My Solution:

 

Révélation
challenge_15_solution_SP.JPG
arjanloogman
Astéroïde

My solution...

JoshuaM
Comète

Forewent an iterative macro for finding the closest warehouse but still got the job done!

acrahen
Astéroïde

My solution

Révélation
2019-01-15_15-51-33.jpg
CobusVenter
Météore

Here is mine.

I haven't done the previous challenge(14) yet, so I didn't understand the relevance of "assigned/priority" yet, so I did the wrong calculation. But, easily rectified, when I learnt that the distance for each store has to be multiplied by the value of "assigned".(per each item)

 

jdunkerley79
ACE Emeritus
ACE Emeritus

Catching up ...

 

Révélation
2019-01-16_17-49-15.jpg
Anastasiia
Astéroïde

Here is my solution

WH
Météore
Révélation

In my solution, Append Fields and Summarize tools are used together with Create Points and Distance tools to get the distance to nearest warehouse.

In standard solution, Create Points and Find Nearest tools are used instead. More simplified solution! Thanks.