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

Will be checking out some of these nostalgic songs.

 

Spoiler
challenge_189.PNG
Highlighted
Asteroid

Preferred creating a solution that contained the full decade alias (e.g., "1960s") so that the 2000s and 2010s weren't the top two records, followed by 60s, 70s, etc. This way the records follow logically by the dates of the decades.

Spoiler
challenge_189_solution_justindavis.PNG
Highlighted
Alteryx Partner

Challenge 189 is done!

 

Spoiler
image.png
Highlighted
Fireball

The results look a little different if you remove the features from the artists. I was surprised when I didn't see Beyonce listed in the 00's and it turns out it's because she had featured artists on  a few of her songs.

Highlighted
Comet

Another nice challenge @ChristineB !

I think I've gone more or less the same as most on this one.

 

thanks,

Aidan

Highlighted
 
Highlighted
Meteor

My solution

Highlighted
Atom

My first challenge!

Spoiler
challenge189gc.PNG
Highlighted
Comet

I've taken a different route to most solutions, without splitting and joining on the top 100.

 

Spoiler
tonyp_0-1573580245001.png
Highlighted
Magnetar
Magnetar
Spoiler
Capture.PNG