We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
alteryx Community

# Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #243: Odd Man Out

8 - Asteroid

I got the same answer as you.

6 - Meteoroid

Solution is attached

Answer to Question 1 - Bolivia, Costa Rica, Ecuador, Panama, Paraguay, Peru, Republica Dominicana

Answer to Question 3 - Bolivia, Ecuador, Cuba, Guatemala, Honduras, Paraguay, Peru

13 - Pulsar
Spoiler

I interpreted Question 1 as the greatest year in the past (<2020) that had male numbers above female
I really don't see how Question 2 can be different though...

Like others I didn't get the same output as the solution, which I think is due to interpretation of the questions. As far as I can tell my solution works for my interpretation of the question (as I'd hope!), but I'm curious to see if and how people have got to the same output...

Spoiler
9 - Comet

A wise person once said  "If you have to repeat something more than 3 times, use a macro". Thus I did not use a macro...

Spoiler

8 - Asteroid

A good lesson in investigating data and doing some engineering. Showing the solution before and after the fix. Both solutions differ from the the stated.

Spoiler
7 - Meteor

Just don't understand how census data is in floats.

My answers didn't match the output data 😕

8 - Asteroid

having looked through @jasperlch solution at least for question 1, I understand now where the discrepancy comes from, and why so many people posted a different solution:

Question 1 asks for the "last year in which there were more men than women in a Latin American country"; you have to add "before it switches to more women", something like that. For example, Peru has more men then women in 2015, but that stays the same in 2020; but for Costa Rica as well as República Dominicana / Dominican Republic, 2015 shows more men, but in 2020 they both have more women. So, in that sense, 2015 is "the last year in which there were more men than women in a Latin American country" .

Tricky..

8 - Asteroid
Spoiler
SOlution Attached

15 - Aurora
Spoiler

8 - Asteroid

My answers differed from solution as well- but seemed to match everyone else's.  1st question is different.

Spoiler