Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

afv2688
16 - Nebula
16 - Nebula
Spoiler

Untitled1.png

Nice 🙂

 

fmvizcaino
17 - Castor
17 - Castor

Solution attached! 

 

Spoiler
fmvizcaino_0-1577131350756.png
JTCairns
8 - Asteroid

This definitely influenced my Playlist for today

brudnicki
7 - Meteor

My solution

Hjardine
8 - Asteroid
Spoiler
Hjardine_0-1577800285380.png
Select tool to switch rank and year to doubles, formula tool to assign decade, summarize tool to count instances of artists, another summarize to count max, join tool to get who had the max count, summarize tool to concatenate each. Same thing for filtered data for top 10.
apabonok
8 - Asteroid

Hi! This is my solution.

A macro could be a good solution in order to do not repeat dataflow.

Spoiler
challenge_189_apabonok_spoiler.png

 

 

AlexSa
Alteryx Alumni (Retired)
 
saravanasriram
7 - Meteor

Solution below

Spoiler
SolutionOutput.png
JustinBabbitt
Alteryx
Alteryx
Spoiler


JustinBabbittEAG_0-1578597482241.png

Thank you! 

Justin Babbitt
mheinze
Alteryx
Alteryx
Spoiler
Use of Summarize concatenating strings is key to getting the format with ties in one line. 
mheinze_0-1578614090283.png