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 #213: Optimized Flower Arrangements

DN
8 - Asteroid
Spoiler
Capture.PNG
aazimh
8 - Asteroid

Definitely needed a refresher on how to use the Optimization tool, but this was fun!

helpfultoaster
Alteryx
Alteryx

Wake up and smell the roses!

phottovy
13 - Pulsar
13 - Pulsar

Definitely got some help from this training video:

 

Prescriptive Optimization 

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

The optimization tool is so much fun 🙂

 

Emil_Kos_0-1621884977672.png

 

Thableaus
17 - Castor
17 - Castor

My solution was slightly different from many others.

 

Spoiler
I used the "Constraint in rows" method, so that's why I used the Cross Tab tool to put the fields in order.
I had to sort the rest of the dataset so the field would match correctly (Cross Tab Tool makes it messy).
The other difference is that I used "==" as my operator, instead of "<=". This is questionable because the exercise says that the florist has a budget of $950. So i think both answers would be right, although the solution provided ends up spending $949.90, mine had an extra cost but it entered the budget.

Thableaus_0-1622702162660.png

 

Cheers,

KilianL
Alteryx Alumni (Retired)

Time to optimize my Alteryx knowledge!

 

Spoiler
213 - Optimized Flower Arrangements - Kilian.png
cwkoops
8 - Asteroid

Matrix & Manual

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission, nice to learn the optimisation tool.

jonathanwillis
8 - Asteroid

This one was tricky. I needed to think through the coefficient values through