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 #109: Women in Government Around the World

Highlighted
Director, Customer Enablement
Director, Customer Enablement

For that last week of International Women's month, we  will looking at data around women holding government positions.  Remember - you this will be the last opportunity to enter into our contest to win the book: "Good Night Stories for Rebel Girls". Simply upload a solution to this challenge and have a chance to win!

 

This week's challenge has us asking: "What are the top 3 countries that had the greatest percent increase in women holding government seats between 1997-2017 for each income group?"

To get to the answer, here some rules on how the data should be treated:


1) We are only looking at data from 1997 to 2017
2) Remove countries not reporting data from 1997-2017
3) If a year is left blank, assume that the percent is the same as the year previous to it
4) The country must have a designated region and income group for analysis - if not, remove it
5) If a country had a drop in percent of seats held by women more than two times, remove it from the list of top performing countries.
6) Of the remaining countries, calculate the total percent change difference between 2017 and 1997
7) Rank the top 3 countries for largest percent change for each income group (expect 12 results)

Alteryx Certified Partner

Fun challenge.  I really got into the 'flow' of analysis and ended up with a bit of a sprawling workflow, but it does the job. 

 

Look forward to seeing this done much more elegantly by others :-D

 

Spoiler
109.png
Spoiler
Capture.PNG
Alteryx Certified Partner

Took me a while, but made it :).

 

Spoiler
109.PNG
Alteryx Certified Partner

Hello, #109 Resolved

Spoiler
Workflow_109_resolved_MM.pngWorkflow screenshot
Alteryx Certified Partner

Got to use my favorite tool, the Multi-Row Formula, twice!

 

Spoiler
weekly_challenge_109.jpg
Inactive User
Not applicable
 
Quasar

This was a fun challenge! 

 

Spoiler
Challenge #109.PNG
Meteor

Here it is...

 

Spoiler
Capture.PNG
Asteroid

My solution.