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
Meteoroide

:)

PrzemekNabozny
Meteoro

Hi,

Solution attached. That one was messy!

Saqueador
flow.png

zraposoaandm
Asteroide
Saqueador
Capture335.PNG
IsaacMojica
Meteoro

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! 

 

Saqueador
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
Magnetar

C335

czello
Asteroide

Nice Challenge to practice using "Contains."

rebecca_petter
Asteroide

Done

mkeiffer
10 - Fireball
10 - Fireball

My solution!

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

YanP
Meteoro

Easy one but wording is partly misleading.

Saqueador
Screenshot 2024-08-07 145110.png

Supriya2203
Asteroide

My solution