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
8 - Asteroid

First try, nice way to be familiar with Alteryx!

Spoiler
Spoiler2019-11-15_190355.png
Highlighted
Alteryx Partner
Spoiler
189.PNG
Highlighted
8 - Asteroid

Interesting data set! and nice and easy challenge

 

Spoiler
image.png
Highlighted
7 - Meteor

Some surprising results....

Highlighted
8 - Asteroid

My solution

Highlighted
6 - Meteoroid
Spoiler
ParadoxuM_0-1573832181675.png

Solution attached

7 - Meteor

Second submittal... did not account for multiple max numbers per decade in first solution

Highlighted
5 - Atom

Most top 100 songs be Decade

 

atasi_0-1573832308000.png

 

Most top 10 songs by decade

 

atasi_1-1573832369632.png

 

#OpTech D&A

Highlighted
8 - Asteroid

Not the most dynamic, curious to look at other solutions to see if anyone used a more dynamic way to group into decades other than IF statement

 

Spoiler
RL_Wk_189.png
Highlighted
7 - Meteor

done in two different approach

one is separating the data for decade by decade and applying the required analysis

other talking the data combined, allowing the decades and then analysing the data