Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Alekh
9 - Comet

 

 

Spoiler
 109.png
hbraunius
8 - Asteroid

My solution attached.

Kenda
16 - Nebula
16 - Nebula
Spoiler
This one was fun, too.

Capture.PNG
TonyA
Alteryx Alumni (Retired)

I really enjoy the data prep challenges. In this one, I made a slight change. Apparently Bolivia was dropped from consideration because it didn't report in 1997 and so it had a null result for 20 year change. I backfilled in both directions -- if a value was still null after filling from previous then I filled from next. That put Bolivia in the number 1 spot for Lower Middle Income.

Vidya26
8 - Asteroid

My Solution!!

grazitti_sapna
17 - Castor

Solution.

Sapna Gupta
RWvanLeeuwen
11 - Bolide

My result is slightly different, but this is probably due to interpretation

Spoiler
I think I interpreted some things differently, such as the "has reported values" which I included with a counts distinct non-null

Something else I did was I first did the multi-row formula to check for empty values and then supplement it with the previous years' value. However, I performed this operation narrowing the data set to the time period of interest

109.png
jyotijyoti_dup_475
8 - Asteroid

Finally done!

OllieClarke
15 - Aurora
15 - Aurora

So many rules!

Spoiler
Challenge 109.png
Laszlo_D
8 - Asteroid

clipboard_image_0.png