ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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!

JBevan89
8 - Asteroid

solution attached

lduong48
7 - Meteor
Spoiler
Screenshot 2025-02-04 124235.png
arianalc21
6 - Meteoroid
Spoiler
Screenshot 2025-02-04 124212.png
Sandy_Wlodarczyk
6 - Meteoroid
Spoiler
Screenshot 2025-02-04 124319.png
VijayChandra
7 - Meteor

Re: Challenge #338: Let's Summarize!

SammiJohnson
8 - Asteroid

My Solution 😁

MonicaRoyal
7 - Meteor

This one was a good reminder to read the instructions CAREFULLY!  

 

Spoiler
Challenge#338_Solution.png

hzmit
7 - Meteor

Let's Summarize

prachitakotangale
7 - Meteor

Solution to challenge #338

3I_ATLAS
9 - Comet

<Got flagged by the censorship police for the plural form of "alb-u-m">

The message body contains b-u-m-s, which is not permitted in this community. Please remove this content before sending your post.

 

Exactly!  As @Sebastian_Chaieb2 , @alexnajm ; @ggruccio and @peter_gb and others have mentioned, this challenge could have had much clearer better instructions. 

"The following dataset contains information about the top 500 songs."  - The dataset only has Alb-u-m-s data!  There are no songs there! :o

" with the most al-b-u-m-s and the highest average rating." - these are two distinct groups that cannot be made into one coherent dataset.

 

So, It becomes a consulting exercise in which we ignore the instructions to some degree and divine for ourselves the metric the client is trying to determine.  If you arrived at a different answer than the one provided, you are probably better off!

 

I personally will go quality over quantity.  Bowie has only 7 albums (still in the top 50 alb-u-m count) but with a beats both John Coltrane (12) and Miles Davis (17), with a 4.015714 average rating.

Spoiler
WC_338.jpg