Spent a while trying to crack the simple logic to this. Got it eventually.
Happy new year all.
My solution - finally! Was determined to figure out the Optimization tool. It has been my arch nemesis for some time now. After this challenge.... still my arch nemesis. :) But I got there eventually!!
What a fun and Community-minded challenge... thanks to all who helped make a difference through both challenge completions AND personal contributions!! Just another example of how this Community is really making a difference in SO MANY WAYS. Love you guys. *tear* :)
What a great challenge to end the year.
I am rather new to Alteryx, and the interest really kicked in after attending Inspire in London last year, but on that conference, I had the great pleasure on attending a session held by the truly inspiring @NicoleJohnson
The topic was these weekly challenges, and that was what really got me kicked into this.
So I have tried to solve them ever since, but sometimes I got stuck, and they took a little more time than anticipated.
I did not manage to finish this in time, so my own solution did not count, but I did get my #SANTALYTICS 2018 badge, which I have put to use in this solution 😆
But before I present my solution, I also have to give a big shout-out to:
@JoeM for putting us up to this, and for his excellent live training on Prescriptive Optimization
@cgoodman3. for pointing out the optimization macro in the first place and of course
@NicoleJohnson, for just being so awesome (and provide solution that helps me go on, when I get stuck)
I have tried to put everything I have learned so far into this solution:
What a great puzzle, and I am looking forward to solve many more this year.
@Verakso, this might be one of the most thorough weekly challenge explanations I've ever seen - it is truly fantastic!! Examples like yours are SO incredibly helpful for the Community at large, and I am honored to be even mentioned - thank you so much for your kind words!! (You too, @JoeM - I am constantly in awe of this beautiful collaboration you & your team have helped to create that brings people like all of us together. THANK YOU!)
Keep charging down this path, Thomas! I can tell you have the enthusiasm and curiosity that will take you extremely far on your journey, especially with the skills it is so clear you have already in creating thoughtful, creative, organized solutions. You even chose the harder route, creating the solution counter on your own (and doing an excellent job of thinking through ALL the requirements, such as date filtering and creating versatility in the future with an app!), so that you could really learn and grow... and that makes all the difference. It is you who are the inspiration!!
Cheers, and thank you for helping me start my day with such a warm smile!! Gosh, I love you all. :)
This was fun! A year ago I'd have never thought that I could build my own tool to scrape multiple pages of a website :)
Mine groups the downloads by user to not double count. I also tried to allocate the items fairly between the items by keeping the cheapest of each item.
Too bad it is too late to make a difference. However this was good practice. It would have been easy to shortcut and do the donation amount split manually, but I decided to link it all together. To choose quantities I decided to distribute the money evenly across the products in each category and rounded up the quantity so the actual purchase distribution was't exactly 50/50 but since it erred on the side of clothing I decided it was a good trade-off.