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.

Weekly Challenge

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

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

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

Submit Feedback

Challenge #145: SANTALYTICS 2018 - Part 1

Emil_Kos
16 - Nebula

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
Jonathan-Sherman
15 - Aurora
15 - Aurora

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
ehughes
9 - Comet

My solution 

Spoiler
Img 145.PNG

bmcclelland46
10 - Fireball

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

 

JennyMartin
9 - Comet
Spoiler
AWC145.PNG

Fun challenge!

johnemery
10 - Fireball

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
JethroChen
10 - Fireball
Spoiler
challenge_145_jc.PNG
WernerE
8 - Asteroid

Thanks

 

WernerE_0-1601378971260.png

 

AryCardoso
8 - Asteroid

Done!

A2H
11 - Bolide
Spoiler
Capture d’écran, le 2020-10-25 à 18.33.42.png