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

Will be checking out some of these nostalgic songs.

 

Spoiler
challenge_189.PNG
Highlighted
8 - 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 Certified Partner
Alteryx Certified Partner

Challenge 189 is done!

 

Spoiler
image.png
Highlighted
11 - Bolide

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
10 - Fireball

Another nice challenge @ChristineB !

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

 

thanks,

Aidan

Highlighted
8 - Asteroid
 
Highlighted
7 - Meteor

My solution

Highlighted
5 - Atom

My first challenge!

Spoiler
challenge189gc.PNG
Highlighted
10 - Fireball

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

 

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