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
My Solution using Iterative Macro:
This macro finds the next closest delivery location so Flora's total miles is a bit less. I also played around with the reporting tools:
As dsmdavid pointed out, there's a difference when you restrict the dataset to the 30 customers closest to the flower shop versus going to the closest customer based on the previous delivery. I did the most efficient route and my iterative macro is based on the latter option.
Since I'm fairly new to iterative macros, I referenced the Santa's First Iterative Macro Community training which was a great resource.
Spoiler
Workflow:
Iterative macro:
