Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #146: SANTALYTICS 2018 - Part 2

T_Willins
14 - Magnetar
14 - Magnetar

I had waaaaayyy too much fun with this.  To quote Monty Python, "Now for something completely different."  I started with the premises of everybody loves surprises, but they still need to get something they want (need) and Christmas should be about the kids.  I split my budget between clothing (green section) and hygiene (red section) to balance purchases (more on that later).  My first filters (other than required) filter the products that reference "child" and "kid" then randomizes the products and amounts to purchase.  This leads to the fun result of every time the workflow is run it produces a different result!  After maximizing my spend on each type, I wanted to be sure I was squeezing out every penny that could be spent on purchasing products, so I took any remaining balance and determined if any additional products could be purchased.  The gold section (final purchases) could be an iterative macro, but running it twice seemed to always work.  With a higher budget, a macro would be recommended.  Browse outputs give a shopping list and the remaining cash balance. 

 

Finally, being inspired by Alteryx and this weekly challenge, I matched the $20 donation Alteryx is giving to A Precious Child.  If you can, I challenge everyone who is posting a solution to do the same.  The link is:  https://donate.apreciouschild.org/

 

Happy Holidays and Happy Alteryxing!

WilliamR
Alteryx
Alteryx

Here is my solution.

I have tried to do something the more dynamic I could but I need to fix the number of webpage to scrap. Items allocation is done incrémenting by one each until to reach the maximum amount. The list is in pdf, ready to be used in the supermarket.

 

Spoiler
workflow.JPG
Spoiler
List.JPG
AJauniskis
8 - Asteroid

My solution. $600 total to spend, 30 solutions so far, with $2.63 left.

 

Spoiler
workflow.JPGtable.png
calampert
7 - Meteor

My solution:

 

 

EW
11 - Bolide
Spoiler
$640 was allocated assuming it was better to use up most of the money than to have exactly a 50/50 split between clothing and hygiene.  Also I spent way too much time trying to figure out what should be considered hygiene products!  I used an item price limit of $15 to get a variety of items.  



146EW1.PNG146EW2.PNG


Also I love the idea of making a donation for real!  Going to do that now.  

CharlieS
17 - Castor
17 - Castor

 

Spoiler

I decided to let a couple of iterative macros keep randomly picking items from each category until nothing else can be purchased.

Challenge_0146-Macros.png











 

TylerNa
10 - Fireball

I went for quantity in my solution. Left $1.90 to still be spent. Merry Christmas and a Happy New Year!

Spoiler
Santalytics 2018 Part2 Workflow.png
ultrarunner
8 - Asteroid

My solution is messy, but I am doing this for a good cause. Learning Alteryx is one of the best things in year 2018. Happy Holidays!

chpoland
7 - Meteor

My solution at $720  Thanks for giving back!!

Spoiler
Result.PNG

Workflow.PNG
ddiesel
13 - Pulsar
13 - Pulsar

This was my favorite challenge to date!

 

Spoiler

Here’s where my brain went with this one:

 

  • Filtered StoreData by the criteria in @JoeM guidelines
  • Filtered by keywords for items listed @ https://apreciouschild.org/take-action/donate-goods/
  • Spent a little extra time removing items with keywords that were irrelevant, inappropriate, or overpriced
  • Created 10 records for each item (to satisfy the no more than 10 items clause)
  • Took half the budget and fed it into an iterative macro that randomly chose clothing items up to the budget
  • Took the remaining donation budget and ran it through the same iterative macro for hygiene items
  • Unioned and Summarized the data into tables with quantity and extended cost
  • Took the opportunity to practice with reporting tools to create a printable PDF (for the very appreciated volunteers that donate their time to do the shopping!)

    Capture.PNG

 

I had $740 dollars to work with, but this is workflow is dynamic to run with any budget. If I were responsible for the product selection, I might run the workflow a few times to get a list that “feels” the right mix of products to donate. There’s only so much we can automate before we need to get down into the weeds.

 

Happy Holidays everyone! See you next year!