Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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 #109: Women in Government Around the World

Verakso
11 - Bolide

It's been a while, so it took me longer than I thought, but eventually I did get there...

Spoiler
My SolutionMy Solution

 

/Thomas

karlynlarson
8 - Asteroid

my solution

SylwiaDragon
8 - Asteroid

I did it, however the results are suspicious, probably there was a mistake in my formulas.

leonhekkert
8 - Asteroid

My solution!

 

Spoiler
Challenge_109.png

My results are a little bit different as I thought we had to skip countries when they had 3 or more consecutive drops in percentage instead of 3 drops regardless of whether they were following eachother. Workflow is more or less the same though.

joelmiller66
9 - Comet
Spoiler
109 screenshot.png
ARussell34
8 - Asteroid

I had to do some re-work a few times in regards to dropping those countries that had a decrease over the year span greater than 2 times, but found the top 3 (12 total) countries for the largest percent change per income group. Rwanda (Low Income) had the greatest change overall at 44.2 and United Arab Emirates (High Income) had the smallest change for this list at 22.5 change.

DataNath
17 - Castor
17 - Castor

My solution to #109.

 

Spoiler
DataNath_0-1647628949657.png

 

mgaronson
11 - Bolide

Phew! Filters, summarizes, joins and more - oh my! Lots of data manipulation with this one. In reviewing solution, I've never used the multi-field formula. This would have been useful in this challenge. Also, isempty vs isnull - hmmm.

Emil_Kos
17 - Castor
17 - Castor

This is quite a mess but I enjoyed this one: 

 

Emil_Kos_0-1649453706047.png

 

TonyAndriani
9 - Comet

Reposting under my new user ID.