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

Nebula

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

 

Dan

Asteroid

My solution and shopping list

Asteroid

Hi! Here my solution :)

Alteryx Certified Partner

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

 

Spoiler
challenge_146.PNG
Alteryx Partner
Spoiler
Spoiler.PNG
Nebula
Nebula

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!

 

Annotation 2019-06-14 133308.png

 

Spoiler

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

Count the solutions.png

Step 2: Then filter the potential shopping list

Solution part 1.pngsolution part 2.png

Step 3: Use an iterative macro to maximize spending:

Iterator.png

Looking forward to seeing how others tackled this one!

 

Alteryx Certified Partner

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


Capture.PNGCaptureit.PNG
Asteroid
Spoiler
146.PNG
Alteryx
Alteryx

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

Bolide

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
Challenge 146.PNG