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
8 - Asteroid
Spoiler
God bless you Dynamic RenameGod bless you Dynamic Rename

 

Highlighted
8 - Asteroid
Spoiler
challenge_145_shvive.png

Ho! Ho! Hope for a better future for everyone! 

Highlighted
Alteryx Partner

First big dataset I've worked with.  Very cool - and soooo much easier than in Excel

 

Spoiler
Perhaps should have linked the data to the field names in Excel, but I sidestepped by searching for and renaming the relevant fields by hand.

Process:
- Filtered charity names for State (Field 4) = CO
- Filtered 990 data with flag from formula tool (combining criteria with ANDs to set prospect flag
- Joined data to names/addreses
- Calculated fundraising efficiency ratio and sorted the 3 final prospects

Yielding "A Precious Child Inc." as the winner.

MySolution.PNG
Highlighted
Alteryx Certified Partner

I chose:

Spoiler
A Precious Child Inc.
challenge 145.png

n.b. the yxzp was too large to post, so I've gone for the workflow without files
Highlighted
Alteryx Certified Partner

Nice one!

 

Spoiler
Challenge 145.PNG
Highlighted
Alteryx Certified Partner

I narrowed it down to three candidates of which I manually selected one that I am most epathetic with:

Spoiler
Healthcare is my go to charity here :)Healthcare is my go to charity here :)
Highlighted
8 - Asteroid
Spoiler
Challenge 145.JPG
Highlighted
8 - Asteroid
Spoiler
Challenge 145 2019-12-06.jpg
Highlighted
8 - Asteroid

Solved!

 

Spoiler
nivi_s_0-1577492252952.png
Highlighted
8 - Asteroid

Hello! This is my solution.

 

challenge_145_apabonok_spoiler.png