Challenge #189: Billboard Top 100

[PuffinPanic]

My solution

[Wansoo_Jang]

Challenge solution submitted.

[jli924]

My solution

[Leonardo-Ceballos]

Hi! Here's my solution.

Spoiler

Spoiler

 

[Leonardo_Ceballos]

Hi! Here's my solution.

Spoiler

Spoiler

 

[vinspad]

At first, I got very different results. At first I was doing multi-rows to separate featured artists so they would get counted as well. That is my lower workflow.

Example: Mariah Carey featuring Boyz II Men gave a count to Mariah Carey and Boyz II Men.

Apparently, that was not the assignment. So I basically duplicated my lower workflow but took out the "featuring" parts and trimmed them off so only one artist could be counted.

However, I don't believe either are fully complete as there are a bunch of artist duos like Diana Ross and Marvin Gaye that also have hits as singles artists, and I could not possibly go through each row to ensure I split them out correctly and give both of the artists their fair share. I believe this is also an issue with Bob Seger as he was listed as Bob Seger, but also as Bob Seger and the Silver Bullet Band. Do I think that create incorrect answers? Possibly. Any duets by singular artists would increase their number. While I believe the artists themselves may be correct, I doubt that their number of top 10 - and especially top 100 - are correct.

[lukemorgan]

Here's my solution!

[Nicholas_14]

Good brain exercise.

[Micah_E]

Spoiler

[SamHD]

Had to switch method half-way through as I hadn't considered joint first place for each decade. Originally tried the Record ID tool and filtering for 1st place.

Spoiler