Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

AYXAcademy
Alteryx
Alteryx

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

 

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.

Aaron_Harter
11 - Bolide

great challenge!

Spoiler
0.PNG
Kenda
16 - Nebula
16 - Nebula
Spoiler
I think the answer provided may have the healthiest countries a little backwards...


Kenda_0-1631538179755.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

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

AkimasaKajitani_0-1631538343664.png

 

AkimasaKajitani_1-1631538365759.png


Blake
12 - Quasar

Demonstrated 2 methods for finding the first in the list. 

 

Spoiler
Summarize and Sample

WC285.png
DaisukeTsuchiya
13 - Pulsar

The results of 2nd Output becomes different. 

Spoiler

キャプチャ.JPG


キャプチャ2.JPG

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

キャプチャ3.JPG

 

clmc9601
13 - Pulsar
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.
Screen Shot 2021-09-13 at 7.25.51 AM.png
Spoiler
Screen Shot 2021-09-13 at 7.25.40 AM.png

 

RolandSchubert
16 - Nebula
16 - Nebula

My solution

 

Spoiler
285.jpg
DeanWest
9 - Comet

Happy to start off the week with this challenge!

 

Spoiler
challenge_285_solution_DeanWest-snippet.png

 

JasonHu
8 - Asteroid

Here is my submission.

Spoiler
workflow.png