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
Asteroide

My solution: 

 

Spoiler
workflow.JPG
kexelby
Meteoro

My solution to this weeks challenge! 

sprodger
Asteroide

My Solution:

 

Spoiler
challenge_15_solution_SP.JPG
arjanloogman
Asteroide

My solution...

JoshuaM
Cometa

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

acrahen
Asteroide

My solution

Spoiler
2019-01-15_15-51-33.jpg
CobusVenter
Meteoro

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 ...

 

Spoiler
2019-01-16_17-49-15.jpg
Anastasiia
Asteroide

Here is my solution

WH
Meteoro
Spoiler

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.