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 #281: Holidays

AYXAcademy
Alteryx
Alteryx

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


This dataset contains a list of holiday dates that are observed by each country from Feb. to Dec. 2020.


Your Challenge is to figure out for that period:
- Which country has the most holidays and how many?
- Some holidays are only observed by one country. Which country has the most unique days off and how many?
- Which day is the most shared in the world as a holiday and which countries are sharing this holiday?

L_T
8 - Asteroid
Spoiler
L_T_0-1629119446170.png

 

Blake
12 - Quasar

Labor day coming soon in the US!!

 

Spoiler
281.png
Aaron_Harter
11 - Bolide

Looking forward to another holiday!

Spoiler
I used unique holiday names in my answer for #4 as we can celebrate more than one holiday on the same calendar date!
0.PNG
patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1629120195850.png

 

DaisukeTsuchiya
14 - Magnetar
Spoiler
キャプチャ.JPG
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
281.jpg

I always believed we had so many holidays in Germany ...
PhilipMannering
16 - Nebula
16 - Nebula

My solution attached.

 

Spoiler
PhilipMannering_0-1629121154978.png

 

Spoiler
PhilipMannering_0-1629131670271.png

 

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1629121453134.png

 

alexnajm
17 - Castor
17 - Castor

My interpretation of the second question seems to be different than most, but I am sticking to it.

Spoiler
challenge_281_start_file_Alex Abi-Najm.PNG