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 #285: Around the world

Alteryx

A solution to last week's challenge can be found here.

This data set provides information that includes rankings and scorings of countries based on happiness, economy, health, family, freedom, generosity, etc. The countries are also categorized into 10 regions.

For this challenge, your goal is to find for each region:
- The country ranking the best for happiness
- And the country with the highest-scoring for Health (Life Expectancy)

Then create two reports (tables) to showcase your findings. Each report must include the country, region, and rank or scoring.

*The start file was updated to correct an error on 9/14/2021.

11 - Bolide

great challenge!

Spoiler
15 - Aurora
Spoiler
I think the answer provided may have the healthiest countries a little backwards...

16 - Nebula

My solution.

Spoiler
But the sample output is strange.
Is the lower value of Life Expectancy higher score?

12 - Quasar

Demonstrated 2 methods for finding the first in the list.

Spoiler
Summarize and Sample

12 - Quasar

The results of 2nd Output becomes different.

Spoiler

2nd Outputs shows worst10 not top10. It should be below.

13 - Pulsar

Thanks for the challenge!

Seems to me that finding lowest "Health" score is not necessarily the "highest-scoring". See spoiler for more details.

Spoiler
@AYXAcademy this column according to the Kaggle dataset is how Health contributes to Happiness. That could be good or bad. Furthermore, if it were a health score, wouldn't higher be better? Looks like the answers were calculated sorting by Health ascending.
Spoiler

16 - Nebula

My solution

Spoiler
9 - Comet

Happy to start off the week with this challenge!

Spoiler

8 - Asteroid

Here is my submission.

Spoiler