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!

AYXAcademy
Alteryx
Alteryx

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

 

Are you wondering which artists produced the top songs? Do you want some insights? This challenge is for you.
 
The following dataset contains information about the top 500 songs. Using the dataset, find the top 50 artists with the most albums and the highest average rating. Include the following columns in your list :
 


- Artist(s)
- Number of albums (Descending)
- Average rating based on all albums (Descending)
- Album title(s)
- Average number of reviews based on all albums (Descending)
- Genre(s)
- Year the first album was released
- Year the last album was released


Note: If in your solution you have null records for the Release Year, do not include them.

 

This challenge was updated to propose 2 start files and 2 solutions.

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
338.png
peter_gb
9 - Comet

I was unable to locate any records with a Null release year using the following:

Spoiler
Year: Right([rel_date],4)

This obviously means my solution doesn't match but I'm happy with it I think - please correct me if I'm mistaken!

Spoiler
challenge_338_pgb.png

Still, a fantastic challenge for learning some alternative configs of the Summarise tool. 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Agree expectations after reading prompt versus given output don't match, but here is my attempt... 

Kenda_0-1664198324671.png

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
I didn't like how the genres were repeated so many times, so I cleaned that field up a little bit with some extra summarizes.

patrick_digan_0-1664198753398.png

 

MilindG
12 - Quasar
Spoiler
MilindG_0-1664198800052.png

 

binuacs
20 - Arcturus
Spoiler
binuacs_0-1664199220647.png

 

ahsanaali
11 - Bolide
Spoiler
Spoiler
ahsanaali_0-1664199645979.png

 

 

Spoiler
ahsanaali_0-1664201535793.png

Removing duplicate Genre(s)

mmontgomery
11 - Bolide

Challenge #338

Spoiler
mmontgomery_1-1664200475914.png

 

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

My Solution in attachment. 

However! I have to disagreed wth the presented results (or I did not understand the objectivse) but in example of Artist "", in the expected output for this artst wa no Max date (last release date) and min was also wrong year. 

Sebastian_Chaieb2_1-1664202365060.pngSebastian_Chaieb2_2-1664202373222.png

 

 

In my solution I user RegEx for year parsing.

 

 

Spoiler
Sebastian_Chaieb2_0-1664202251811.png

 

Thanks,

Sebastian