Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAAs 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.
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.
Another nice and straightforward week
Challenge Solution:
All,
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...
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.
outputs didn't quite match but two approaches i'm happy with