Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
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

Highlighted
Alteryx
Alteryx
Spoiler
189_screenshot.png
Highlighted
Alteryx Partner

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
Highlighted
Alteryx Certified Partner

Here's my solution.

Thanks,

Chris

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

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

Highlighted
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

 

Highlighted
8 - Asteroid

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

Spoiler
ZHSOL.png
Highlighted
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
Highlighted
Alteryx Partner

Let's reuse some logic, shall we?

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

Almost forgot these challenges existed! Thanks for the challenge!

 

nerces_0-1573801069926.png