community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #146: SANTALYTICS 2018 - Part 2

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
Director, Customer Enablement
Director, Customer Enablement

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

Director, Customer Enablement
Director, Customer Enablement

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

 

 

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
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

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

Magnetar
Magnetar

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

Thanks for this challenge!

Learned a lot while going through it.

 

Spoiler
AWC_146.JPG
Fireball

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

Alteryx Certified Partner

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

Spoiler
challenge146.PNG