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 #335: Movie Decisions

reavenxx
6 - Meteoroid

:)

PrzemekNabozny
7 - Meteor

Hi,

Solution attached. That one was messy!

Spoiler
flow.png

zraposoaandm
8 - Asteroid
Spoiler
Capture335.PNG
IsaacMojica
7 - Meteor

It was demanding, using your creativity to solve these challenges by different methods will always be my Alteryx's favorite ingredient. Reading all your replies, watching spoilers and solutions right after completing a challenge helps me learn how to optimize efficiency and tool usage for future reference. Great Community! 

 

Spoiler
image.png
1.Cast appropiate datatypes
2.Filter Null values
3. Sort by Diva Score, Revenue, Popularity
4.Filters By Genre(s)
5. Select First Record
6. Find Max Revenue, join to get the actor and Ideal Film Location
7. Union by matching fields
8. Find Average revenue(expected revenue)
9.Drop unnecesary Columns
10.Union all rows by position
11. Create criteria column with description for each result. (To match challenge output basically)

aatalai
14 - Magnetar

C335

czello
8 - Asteroid

Nice Challenge to practice using "Contains."

rebecca_petter
8 - Asteroid

Done

mkeiffer
10 - Fireball
10 - Fireball

My solution!

Spoiler
Screenshot 2024-08-01 at 10.00.40 AM.png

YanP
7 - Meteor

Easy one but wording is partly misleading.

Spoiler
Screenshot 2024-08-07 145110.png

Supriya2203
8 - Asteroid

My solution