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.

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 #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
16 - Nebula
16 - Nebula
Spoiler
patrick_digan_0-1629120195850.png

 

DaisukeTsuchiya
12 - Quasar
Spoiler
キャプチャ.JPG
RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
281.jpg

I always believed we had so many holidays in Germany ...
PhilipMannering
14 - Magnetar
14 - Magnetar

My solution attached.

 

Spoiler
PhilipMannering_0-1629121154978.png

 

Spoiler
PhilipMannering_0-1629131670271.png

 

 

Kenda
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1629121453134.png

 

alexnajm
8 - Asteroid

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