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 #146: SANTALYTICS 2018 - Part 2

Highlighted
8 - Asteroid
Spoiler
My workflow requires a little bit more manual intervention the the others posted but here is my list (targeting higher priced "Hygiene" items while purchasing the max amount of Clothing items without going over budget $760 total)

Santalytics-Pt 2.PNG
Highlighted
Alteryx Community Team
Alteryx Community Team

@T_Willins @EW, I followed your lead and locked in a donation of my own! 

Highlighted
Alteryx Community Team
Alteryx Community Team

Let's get all the solutions in we can today and get as high as we can go. 

 

Am I 'beating the system' for good with this one?

Spoiler
donation.png

 

 

Highlighted
Alteryx
Alteryx

The benefits of going later in this challenge is it makes you feel like you are doing more for charity. 

 

I had a whopping $780 to donate and spread across my items.

 

Spoiler
I went with using the customer ratings as the sort order as this meant that we were able to donate items most valued.

Managed a total of 88 items
Highlighted
Alteryx Alumni (Retired)

@JoeM: 🙈

 

All of this solving is kicking my giving spirit into overdrive! I love that a few folks in the thread have made personal donations in addition to contributing a solution toward our Alteryx For Good donation. I love it so much that I'm going to personally double-down. Here's the deal:

 

  1. Post a solution to this thread if you haven't already
  2. Make a charitable donation to a reputable charity of your choice today
  3. Send me a picture of your receipt (I'll accept anything from Wednesday, December 19th through Friday, December 21st 11:59 PM Pacific time)
  4. I'll match your personal donation dollar-for-dollar up to some reasonable (or potentially unreasonable) number. My matching donation will go to A Precious Child

Let's do this together.

 

Go!

 

CC: @T_Willins@EW

Highlighted
8 - Asteroid

This is such a great idea!

 

Nice to get a chance to revisit the optimisation tool. Still have to look at the example workflows everytime I it.

 

Spoiler
Ch146_solution.PNG

 @BrianO: Check your inbox...

Highlighted
ACE Emeritus
ACE Emeritus

Probably going to tweak/refine/rewrite this solution later tonight, but wanted to put up a solution before it was too late!

Spoiler
I did some filtering of high-dollar items since there were things which cost hundreds of dollars that I just felt were less valuable overall.  I also used a weighted valuation of the customer rating * sale Price to sort the data, so that high-rated items that were more expensive could beat out cheaper items in some cases.

EDIT: Updated this when I got home, and fixed some silliness from me going too fast.

 

Spoiler
My weighted valuation was reversed - I needed to divide sale price by customer rating to get the weighted valuation I was looking for, and sort ascending. This also removed the need for a high-priced filter. I also modified my logic to use an iterative macro, instead of running totals, which increased the number of items I picked from 232 to 325.

2f0e68f2314945e4dff601811eedf274.png
Highlighted
8 - Asteroid

Thanks for this challenge!

Learned a lot while going through it.

 

Spoiler
AWC_146.JPG
Highlighted
11 - Bolide

At the time I ran mine (6:21 PM Eastern), there were 43 solutions. With mine, there are 44 solutions --> $880 to spend!

 

challenge_146_output.png

 

 

Spoiler

My strategy was:
* Limit categories to basic hygiene and kids' clothes (using this list: https://apreciouschild.org/take-action/donate-goods/)
* Within each category, sort by customer rating and buy 10 of each item until no more items can be purchased. This strategy potentially limits the time spent sorting and stocking the items at A Precious Child's resource centers by concentrating on a smaller number of items.
* After allocating within each category, pool the small leftover $ amounts from each category, and attempt to buy more items (even if it violates the 10 max rule, because we may be able to squeeze in something else if it's low priced).


challenge_146_solution.png


Iterative macro that cycles through Community pages until failure:
challenge_146_scraping_macro.png

Highlighted
Alteryx Certified Partner

My solution with $880 ($0.34 leftover)! (Got a bit stuck with this one, but learned a lot.)

Spoiler
challenge146.PNG