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
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.

Challenge #189: Billboard Top 100

AmeliaG
Alteryx
Alteryx
Spoiler
189_screenshot.png
SueDonim
8 - Asteroid

Definitely something wrong with that Top 10 (as noted above).  Also wondering where is "Heaven on the 7th Floor"?  But at least "Muskrat Love" showed up

 

Spoiler
Process:
- Auto-field ('cause I'm lazy)
- Create decade field
- Group by decade and artist + count distinct song
- Sort by decade (asc) and song count (desc)
- Calculate max number of songs for each decade
- Join data
- Group by decade, max song count, concatenate artist

For Top 10: Added filter at front end

MySolution.PNG
chris_ramsay
8 - Asteroid

Here's my solution.

Thanks,

Chris

viveknshah
8 - Asteroid
Spoiler
challenge_189_shvive.png

One month of no internet and whats the first thing I do - come back to solve the latest weekly challenge. Have you been missed and and a nice one to get me back in the groove. Also totally surprised with the results. This generations' music tastes need some alter-ing.

MDOstroff
Alteryx
Alteryx

According to the Rock Music Timeline web site (http://www.rockmusictimeline.com/1960s.html), The Beatles had three top 10 singles in the 60's, but this challenge's data set starts at 1965 so it misses "I Want to Hold Your Hand" which hit the top 10 in 1964. And as far as MJ, Thriller was the #1 album of the decade, but the song itself was only #95 for the decade. In other words, The Beatles (and Elvis) were successful on both the album and singles charts in the 60's, but MJ ruled the 80's album charts only.Odd but true.

jmt214
8 - Asteroid

@RobertW Thanks! I noticed that as I started going through the other solutions. Trying to work too fast I suppose!

 

Here's my revised solution!

 

Spoiler
Capture.PNG

 

Zenon
8 - Asteroid

Fun challenge with us being in crossing over into a new decade. 

Spoiler
ZHSOL.png
TylerNa
9 - Comet

I may have taken more of a jam band or guitar solo approach to this when compared to other solutions.

Spoiler
WC 189 Billboard TN.png
_enrique_javier
7 - Meteor

Let's reuse some logic, shall we?

Spoiler
Using a macro to reuse the logic.Using a macro to reuse the logic.
nerces
8 - Asteroid

Almost forgot these challenges existed! Thanks for the challenge!

 

nerces_0-1573801069926.png