alteryx Community

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.

Challenge #395: Bone-Chilling Horror Movies

Alteryx

A solution to last week’s challenge can be found here.

This Halloween challenge was kindly contributed by Kenda Sanderson (@Kenda). We extend our gratitude to Kenda for her significant contributions to our Community!

Are you of the opinion that modern scary movies are better than their predecessors, or are you a devoted fan of classic directors like Polanski and Hitchcock?

In this challenge, you will immerse yourself in the realm of horror films to discover whether their ratings and earnings have improved over the years or if the classics remain unbeatable. The provided IMDb (Internet Movie Database) dataset encompasses a compilation of horror movies released over the last 100 years.

For this challenge, you should focus exclusively on horror genre movies, and exclude any films that are also considered comedies.

• Calculate a weighted movie rating for each decade, with the number of votes serving as the weight. All movies possess a rating, so they can all be included in this task, even if their revenue data is unavailable.
• Calculate the average earnings for each decade, considering only movies with reported revenue values.
• Create a line graph to visualize the changes in ratings and revenue over time.

• When you calculate the weighted movie rating, you can think of it like a SUMPRODUCT function in Excel.

Source: https://www.kaggle.com/datasets/shreyanshverma27/imdb-horror-chilling-movie-dataset

17 - Castor
Happy Halloween!!!

Spoiler

16 - Nebula

Solution attached.

Chart

Spoiler

Workflow

Spoiler

16 - Nebula
Spoiler
9 - Comet

My try

Spoiler
Spoiler
12 - Quasar

wrapping my head round excel speak was a challenge - got there eventually

Spoiler
13 - Pulsar
Spoiler

Could have been plenty cleaner but was just experimenting while trying to work out what was being asked

8 - Asteroid
Spoiler
8 - Asteroid

Done!

Spoiler

8 - Asteroid
Spoiler

my solution