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

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 Certified Partner
Spoiler
challenge_189_BH.PNG

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

Highlighted
Alteryx Certified Partner

That top 10 list is surprising...

Spoiler
Challenge 189.png
Highlighted
Alteryx Certified Partner

This challenge struck a chord with me!

 

Spoiler
189 AH Solution.PNG
Highlighted
Alteryx
Alteryx

Nice warm-up for a Monday morning!

Highlighted
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

 

Highlighted
12 - Quasar

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

Highlighted
13 - Pulsar

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

 

Spoiler
Workflow 189.JPG

 

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

 

Spoiler
JohnJPS_0-1573495940164.png