This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
2022.1.1.30569 Patch Release Update
The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs.
If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.
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)
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:
Post a solution to this thread if you haven't already
Make a charitable donation to a reputable charity of your choice today
Send me a picture of your receipt (I'll accept anything from Wednesday, December 19th through Friday, December 21st 11:59 PM Pacific time)
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
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.
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.
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).
Iterative macro that cycles through Community pages until failure: