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
Asteroid

First try, nice way to be familiar with Alteryx!

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

Interesting data set! and nice and easy challenge

 

Spoiler
image.png
Highlighted
Meteor

Some surprising results....

Highlighted
Asteroid

My solution

Highlighted
Meteoroid
Spoiler
ParadoxuM_0-1573832181675.png

Solution attached

Highlighted
Meteor

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

Highlighted
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
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
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