Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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 #338: Let's Summarize!

Ray_Pospisil
8 - Asteroid

We were given a different data set:

1/ as there were no Nulls after parsing the Year

2/ John Coltrane is missing in provided solution

Also, the solution did not use secondary sorting by Average Rating as well as did not use Min and Max on Release Year (thus, not portraying the correct picture)

Ray_Pospisil
8 - Asteroid

Majority agreed that we get different results from suggested solution.

Check submitted workflows of others to identify learning opportunities :)

alexismerino
6 - Meteoroid

Where is Coltrane?? Why filter Various Artits if you didn't say anything about it?? 

FloSchoch
7 - Meteor

Sadly here's another challenge with an incorrect output provided.
Fun challenge, but disappointing when searching for mistakes you did not even make.
Had no effort do clean up genres afterwards.

 

Here's my solution:

Spoiler
FloSchoch_1-1664441790904.png

 


 

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached,

 

Spoiler
PhilipMannering_0-1664441683275.png

 

And in the Python Tool,

Spoiler
PhilipMannering_1-1664442876333.png

 

JereJussila
8 - Asteroid
Spoiler
JereJussila_0-1664449503131.png

 

Seems like the proposed solution was missing some names :)

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my workflow !

mg46
8 - Asteroid
Spoiler
mguarniere_0-1664460148559.png

 

My solution

braveraj
11 - Bolide

braveraj_0-1664467278510.png

 

Luke_C
17 - Castor
17 - Castor
Spoiler
Luke_C_0-1664472840356.png

 

Like others have said, slightly different results than the 'solution'.