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

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #266: Mother's Day Bouquet

Alteryx

A solution to last week's challenge can be found hereSource: https://nymag.com/strategist/article/best-mothers-day-flowers.html

This week's challenge was submitted by @sara_burk  - Thanks for your submission!

Flora is the owner of Flora's Flower Décor and More. Each year, she systematically plans out her delivery schedule for Mother's Day deliveries and what the most efficient delivery route will be.

Considerations:
1) Flora always creates her delivery schedule on the day before Mother's Day. This year Mother's Day falls on May 9th. Any order placed on or after May 8th will be available for in-store pick up only.
2) In order to qualify for delivery, the order cost must reach \$50.
3) Flora only has time to deliver flowers to the closest 30 customers to the floral shop. The rest of the customers will have to pick up their flowers from the store.

Flora will start at the flower shop, and consecutively go to the next closest location (based on distance, Miles). Create a macro that will help Flora optimize her route and then map the outcome. How many miles will Flora drive?

16 - Nebula

I must remember to... oh wait.. the UK Mother's Day was several months ago.. : /

Spoiler

11 - Bolide

Might we worth revising that strategy, Flora...

Spoiler

going from closest point to next closest point

vs

restricting to 30 closest points to Flora's shop

16 - Nebula

My solution.

Spoiler

Macro :

13 - Pulsar

Here is my solution!

Spoiler
Workflow:

Iterative Macro:

Map Output:

Number Miles:

56.1356

Cheers!

Phil

16 - Nebula
Spoiler
13 - Pulsar

My solution!

Spoiler
56 miles (no return)
63 miles (including return)

48 miles (including return, using @dsmdavid's strategy. You're right-- it's still more efficient!)

8 - Asteroid

Great challenge.

Spoiler

Iterative macro:

12 - Quasar

I built it with two options, closest to the store or closest to the previous delivery:

Spoiler

8 - Asteroid
Spoiler

A slightly different route, going to the nearest next stop and a long trip home 48.29 miles in total