We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. 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
13 - Pulsar
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
15 - Aurora

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