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.

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

SimonEvans
8 - Asteroid
Spoiler
Weekly Challenge 266 (1).PNGWeekly Challenge 266 (2).PNGWeekly Challenge 266 (3).PNG
Adrian_T
Alteryx
Alteryx

Great exercise!

 

Adrian_T_0-1629184098156.png

 

Michael_McKee
Alteryx
Alteryx

My First Macro

SonaliBabar
8 - Asteroid

My Solution using Iterative Macro:

SonaliBabar_0-1630385998184.png

SonaliBabar_1-1630386067470.png

SonaliBabar_2-1630386111562.png

 

 

Sebastiaandb
11 - Bolide

Here is my solution!

 

Spoiler
Sebastiaandb_1-1633525174565.png

 

JosephSerpis
16 - Nebula
16 - Nebula

Challenge Completed

 

Spoiler
Weekly_Challenge_266.JPG
BronzeFox
8 - Asteroid

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:

 

 

Spoiler
BronzeFox_0-1635796522780.png

 

 

 

JoshuaGostick
11 - Bolide

My solution

 

Spoiler
challenge_266_macro.PNG

challenge_266.PNG
gsanchez
Alteryx
Alteryx

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:
gsanchez_0-1636757833866.png

 

Iterative macro:
gsanchez_1-1636757874694.png
Galilea Sanchez
Technical Customer Success Manager
Alteryx