Challenge #146: SANTALYTICS 2018 - Part 2

[danilang]

Late to the party(again).  But echoing @kat's sentiment, it's been a fun journey from opening Alteryx for the 1st time 10 months ago to scraping the community site and building an optimization model today.  I've worked with a lot of languages/no-code packages in my time going way back to 6510 assembly language and Alteryx is an almost perfect blend of user-friendly development environment coupled with an extremely deep tool kit that is easily extensible.  

Spoiler

Dan

[ipeng]

My solution and shopping list

[RichoBsJ]

Hi! Here my solution :)

[JoshuaGostick]

Only counted users who posted more than one attachment as one for total number of solutions.

Spoiler

[juansagasta]

Spoiler

[SeanAdams]

So - I went completely over the top on this one - and built a few reusable Lithium connectors - seems to have worked well.

Thanks to @cgoodman3 for the solution using the optimization tool - I've not used this yet!

Spoiler

Step 1: get the solution count.    Built some reusable macros for the Lithium (community) API



Step 2: Then filter the potential shopping list



Step 3: Use an iterative macro to maximize spending:

Looking forward to seeing how others tackled this one!

[LordNeilLord]

My solution

Spoiler

I cheated and used the solution counter macro 😞

I made and iterative macro that randomly picks items from the list until all the money is gone...total 333 items selected

[fmeo]

Spoiler

[TonyA]

Hardly my best effort. Needed a lot of tweaking to get a decent result. Looking forward to seeing how others solved this.

[cplewis90]

Trying to finish the last few challenges to be 100% on all challenges. I took a bit of the easy route with the macro, but have plans to go back and do the download myself.

Spoiler