Challenge #338: Let's Summarize!

[lugesy]

My outputs don't match with start file's outputs. 3rd record for John Coltrane is missing in the start file's output. (Updated)

[sergejs_kutkovics]

As have been mentioned in many replies, dataset result doesn't match the output provided. I believe First and Last year mean oldest and newest album respectively. I used min and max year functionin Summarize, not just First and Last one.
Also made a list of distinct genres for each artist.

Spoiler

[NicolaMahood]

It amazes me the different ways people do this! Same as a few have said, had no null years, so the results are different, but here is my attempt!

[JokeFun]

Me too, there's no Null year records. And I have a different result. For example, the year of the first album for Miles Davis is 1957, but the result has 1959. I think my result is correct.

[JamesCharnley]

Spoiler

Another nice and straightforward week

[Brian32]

Challenge Solution:

Spoiler

[Reesetrain2]

All,

Spoiler

Miles Davis was sure Busy!

My solution is below: I had some discrepancies, as John Coltrane was in my final solution with twelve albums all with release years...

 

[janwisniewski]

This was a great challenge to learn more of the advanced options of the summarize tool!

I was surprised about the outcome of "Year the first album was released" and "Year the last album was released". I used Min / Max function here instead of First/Last due to the wording of the challenge.

[EFLOw]

Spoiler

[Joe_Tipper]

Spoiler

outputs didn't quite match but two approaches i'm happy with