Weekly Challenge

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

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

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

Challenge #111: Make a Weekly Challenge Dream Team!

Highlighted
8 - Asteroid

Ughh, I spent a lot of time trying to get it - Alteryx kept giving me some strange errors.

Then finally I disconnected Optimization tool and connected it again. And suddenly everything started to work 🙂

 

Anyway, it was a good exercise to find out how to use Optimization tool

Highlighted
8 - Asteroid

this was trickier than I had expected, but it was definitely cool to be able to solve a system of hundreds of equations by using the optimize tool. 

 

the tool is definitely not easy to configure, but having this as a reference (translating the equations to the tool inputs) may help!

 

🙂

Highlighted
11 - Bolide

My solution is pretty similar to many others...

 

Spoiler
I recently updated Alteryx Designer, so I haven't jumped through all of the IT hoops yet to get the predictive tools reinstalled. Therefore, I went with the heuristic approach! In this case, it yields the same results as the optimal solution.

challenge_111_result_team.PNG
challenge_111_result_count.PNG


challenge_111_workflow.PNG




Highlighted
8 - Asteroid

Really great challenge to learn how to use the optimization tool!  I am glad others posted a link to the Fantasy Baseball example to be able to better understand what the inputs to the Optimization tool needed to be.  It was very helpful.

 

Spoiler
Challenge 111 Screenshot.JPG
Highlighted
8 - Asteroid

Hi! Here my solution 🙂

 

Spoiler
challenge_111.PNG
Highlighted
Alteryx Certified Partner

First time using the Optimization tool and definitely won't be the last!

Spoiler
challenge_111.PNG
Highlighted
8 - Asteroid

My solution attached.

This challenge is very similar to the baseball player lineup one in the past, but simpler. 

Optimization tool rocks!

Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
At first, I was going to try all of the combinations of people and scores/prices, but that was taking wayyyyyyy too long...
Capture.PNG

So I tried a different route. I definitely relied heavily on this tool mastery to help solve this one! 
2.PNG

It's crazy to think that just one year ago, when this challenge was originally posted, I had only done 12 challenges! Now I'm on my way to 100% completion!

Highlighted
8 - Asteroid

Hope to be drafted one of these days!

Highlighted
8 - Asteroid

My solution attached. First time trying the optimization tool! Had to 'cheat' and look at how others configured it.