Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #189: Billboard Top 100

Highlighted
Sr. Instructional Designer
Sr. Instructional Designer

A solution to last week's challenge can be found here!

 

Nothing makes you feel quite as nostalgic as hearing a song you haven't heard in a while.  That's probably why Billboard magazine has been publishing their "Hot 100" list since 1958. If you aren't familiar, the "Hot 100" list ranks the top 100 singles in the US each year. It can be pretty fun to read through, but let's take a look at who dominated the decades.

 

This challenge's dataset includes rankings from 1965-2015. Determine which artist(s) created the most top 100 hits in each decade. Then, try the same but with top 10 rankings.

record.png

Highlighted
Alteryx Partner
Spoiler
challenge_189_BH.PNG

What do you call a musician with problems?
A trebled man.

Highlighted
Alteryx Partner

That top 10 list is surprising...

Spoiler
Challenge 189.png
Highlighted
Alteryx Partner

This challenge struck a chord with me!

 

Spoiler
189 AH Solution.PNG
Highlighted
Alteryx
Alteryx

Nice warm-up for a Monday morning!

Highlighted
Meteor

I had to get the century order in there to.  

 

@OllieClarke the top 10 definitely looks odd. Pretty sure MJ had more than 3 top 10's in the 80's. And the Beatles 2 top 10's 60's.   

 

Spoiler
PaulFound_0-1573492807801.png
PaulFound_1-1573492944020.png

PaulFound_2-1573492974325.png

 

Highlighted
Quasar

Been a minute since I've had time to complete one of these...

Highlighted
Quasar

A wonderful way to start a Monday - the Alteryx Weekly Challenge!

 

Spoiler
Workflow 189.JPG

 

Highlighted
Spoiler
Annotation 2019-11-11 125758.jpg
Highlighted
ACE Emeritus
ACE Emeritus

 

Spoiler
JohnJPS_0-1573495940164.png