We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #219: Who Runs The World? Girls

Daniel_Homola
8 - Asteroid

Here!

Bennu
8 - Asteroid
Spoiler
WC_219.jpg
Arran_S
8 - Asteroid

Attached

jli924
8 - Asteroid

My solution

mceleavey
17 - Castor
17 - Castor

I had to read that a few times before I understood it because of that brain thing...

 

Spoiler
Workflow.jpg

I first filtered to Grade 8, Female and years, then summed ' Level 4 and Number tested by District and year. I then created the calculation and crosstabbed grouping by District with the Year as the header and the % calculation as the values. Then I simply calculated the difference, sorted accordingly and took the top three.

M.



Bulien

Endeavour
9 - Comet

Hi all,

 

Here is my solution.

Spoiler
Challenge_219.png

Thank you