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

My solution:

Spoiler
challenge 189.JPG
Highlighted
8 - Asteroid

I used distinct songs, because I think otherwise we won't be looking at the "most top 100 hits", but the most number of times someone has appeared in the top 100. It's about the songs/hits, not just the artist.

 

So for example Because of You and Breakaway by Kelly Clarkson appear twice (2004/2005 and 2005/2006). The same goes with songs by Pink, Taylor Swift and Mariah Carey.

Highlighted
7 - Meteor

Here's my solution

Highlighted
5 - Atom
Spoiler
czb_0-1574177708374.png

 

Highlighted
10 - Fireball

Here's my solution

 

Spoiler
Used a summarise and join to get the artists witht the most top 10's by decade. Would typically use a append and filter but think the join method is smarter.

Challenge 189 solution.PNG
Highlighted
Alteryx Certified Partner
Spoiler
screenshot189.png
8 - Asteroid
 
Highlighted
12 - Quasar

My solution. There si probably an easier way to do this. Curious to see other solutions!

Spoiler
Challenge 189.PNG
Highlighted
6 - Meteoroid
Spoiler
Federico_Albano_2-1574351031749.png
Highlighted
5 - Atom

Very Nice Solution!