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.

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

Challenge #189: Billboard Top 100

ChristineB
Alteryx
Alteryx

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

Blake
12 - Quasar
Spoiler
challenge_189_BH.PNG

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

OllieClarke
13 - Pulsar
13 - Pulsar

That top 10 list is surprising...

Spoiler
Challenge 189.png
Aaron_Harter
11 - Bolide

This challenge struck a chord with me!

 

Spoiler
189 AH Solution.PNG
TonyA
Alteryx
Alteryx

Nice warm-up for a Monday morning!

paulfound
11 - Bolide

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

 

neilgallen
12 - Quasar

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

T_Willins
13 - Pulsar
13 - Pulsar

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

 

Spoiler
Workflow 189.JPG

 

patrick_digan
16 - Nebula
16 - Nebula
Spoiler
Annotation 2019-11-11 125758.jpg
JohnJPS
15 - Aurora

 

Spoiler
JohnJPS_0-1573495940164.png