community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
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.

Challenge #109: Women in Government Around the World

Alteryx Partner
Spoiler
Challenge109.PNG
Alteryx Certified Partner

Done !

Alteryx Certified Partner

Fun challenge!

Meteoroid

Nice logical steps

 

Spoiler
Challenge_109_solution.JPG
Asteroid

This was anonymised for us as an internal exercise, but I tracked it down!

Highlighted
Meteoroid

My Solution:

Spoiler
109.JPG
Asteroid

Here goes!

Meteor

Not the most elegant in the world but it works! 

Spoiler
Screenshot (237).png
Asteroid

I made this one a bit more complicated than necessary, because I wanted to make the workflow dynamic (in case we wanted to run this for different begin/end years).
Rather than creating an app, I just added two workflow constants to capture the begin and end years.

 

Spoiler
challenge_109_workflow.png
Meteor

Very fun challenge!  Love that multi-row formula tool!

 

Spoiler
Challenge 109.JPG