We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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
15 - Aurora
15 - Aurora
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
11 - Bolide
Spoiler
MilindG_0-1664198800052.png

 

binuacs
17 - Castor
Spoiler
binuacs_0-1664199220647.png

 

ahsanaali
8 - Asteroid
Spoiler
Spoiler
ahsanaali_0-1664199645979.png

 

 

Spoiler
ahsanaali_0-1664201535793.png

Removing duplicate Genre(s)

mmontgomery
8 - Asteroid

Challenge #338

Spoiler
mmontgomery_1-1664200475914.png

 

Sebastian_Chaieb2
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