Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

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

Challenge #145: SANTALYTICS 2018 - Part 1

Highlighted
12 - Quasar

Hi,

 

Sharing my solution. I have downloaded the data and made some changes in the separate workflow. Thanks to that I could limit number of the rows and speed up the building process.

 

Spoiler
Challenge_145_Emil_Kos.PNG
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

I've been practicing prescriptive tools recently and thought i'd have a go at solving the question using the optimization tool! (yes i know i've over complicated it - but why not sometimes!)

 

Workflow:

Spoiler
challenge 145 JMS solution.PNG

Charity Chosen:

Spoiler
challenge 145 JMS solution charity.PNG
Highlighted
8 - Asteroid

My solution 

Spoiler
Img 145.PNG

Highlighted
9 - Comet

For whatever reason the text file took forever to blend so I bit the bullet and did a nasty crosstab that took 7 minutes then just saved as an alteryx dbase. No run took more than 7 seconds after that. Container has the data processing and the bottom bit actually solved the question. Fun data crunching.

 

Spoiler

bmcclelland46_0-1597198123426.png

 

Highlighted
Alteryx Partner
Spoiler
AWC145.PNG

Fun challenge!

Highlighted
Alteryx Partner

My answer is different than many others. Doing some digging, it seems that my list of charities doesn't include what many of the first posters answered with. I guess it changed.

 

Spoiler
Capture.PNG
Highlighted
Alteryx Partner
Spoiler
challenge_145_jc.PNG