Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
alteryx Community

# 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.

## 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
16 - Nebula
Spoiler
I think the answer provided may have the healthiest countries a little backwards...

17 - Castor

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

13 - Pulsar

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