The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
Astéroïde
Révélation
L_T_0-1629119446170.png

 

Blake
Quasar

Labor day coming soon in the US!!

 

Révélation
281.png
Aaron_Harter
Bolide

Looking forward to another holiday!

Révélation
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
Révélation
patrick_digan_0-1629120195850.png

 

DaisukeTsuchiya
14 - Magnetar
14 - Magnetar
Révélation
キャプチャ.JPG
RolandSchubert
16 - Nebula
16 - Nebula
Révélation
281.jpg

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

My solution attached.

 

Révélation
PhilipMannering_0-1629121154978.png

 

Révélation
PhilipMannering_0-1629131670271.png

 

 

Kenda
16 - Nebula
16 - Nebula
Révélation
Kenda_0-1629121453134.png

 

alexnajm
19 - Altair
19 - Altair

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

Révélation
challenge_281_start_file_Alex Abi-Najm.PNG