Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #189: Billboard Top 100

tiffany_chen
8 - Asteroid

First try, nice way to be familiar with Alteryx!

Spoiler
Spoiler2019-11-15_190355.png
dombaikamilla
8 - Asteroid
Spoiler
189.PNG
hanykowska
11 - Bolide

Interesting data set! and nice and easy challenge

 

Spoiler
image.png
dholle1958A
7 - Meteor

Some surprising results....

Illya
8 - Asteroid

My solution

Axiom
7 - Meteor
Spoiler
ParadoxuM_0-1573832181675.png

Solution attached

dholle1958A
7 - Meteor

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

atasi
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

rslopez2
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
Htaneja2
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