Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #189: Billboard Top 100

ChristineB
Alteryx Alumni (Retired)

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
15 - Aurora
15 - Aurora

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 Alumni (Retired)

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
14 - Magnetar
14 - Magnetar

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

 

Spoiler
Workflow 189.JPG

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
Annotation 2019-11-11 125758.jpg
JohnJPS
15 - Aurora

 

Spoiler
JohnJPS_0-1573495940164.png