Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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 #416: The Oscars 2024

RobbieA
8 - Asteroid

Hope Barbenheimer wins

Spoiler
 
 

 

 

 
Screenshot 2024-03-04 191919.png
oscar_leeper_wf
7 - Meteor

That was some good exercise

Spoiler
Challenge_416_spoiler.png
cdoors54
5 - Atom
Spoiler
1.PNG
2.PNG
3.PNG
4.PNG
5.PNG
TurboToad
10 - Fireball

My take. Liked the solutions that used a formula tool to convert the winner true/false to a number. 

Spoiler
416.PNG
nSpire
9 - Comet
Spoiler
416.png
Watermark
12 - Quasar
12 - Quasar

 

Ask me about movies  ;-)_

 

Spoiler
MT_Solution_416.jpg

 

Qiu
21 - Polaris
21 - Polaris

@AYXAcademy 
I am so happy that my challenge idea gets accepted and published.
And so looking forward to the special Swag. 😁

AkimasaKajitani
17 - Castor
17 - Castor

@Qiu -san, Great challenge!!

 

Spoiler
Clipboard01.png
At the task2, I think that the output does not contain the records that have 0 award count.

Clipboard03.png

gawa
16 - Nebula
16 - Nebula

@Qiu Fun challenge! How many swags do you have now?😁

Spoiler
image.png
alanbelemb
5 - Atom

This is my first challenge, and It was really cool to do it!

 

I did a little detour. I noticed the original dataset for 2024 had only best leading actor and best leading actress. So I used the Download tool to get information of the oscars site and parsed, making a dataset of all nominees and categories. This led to differences in task 1, 4 and 5 results.

 

Hope you like my solution.

 

It was a nice challenge!