Challenge #189: Billboard Top 100
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
afv2688
16 - Nebula
12-20-2019
05:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
fmvizcaino
17 - Castor
12-23-2019
12:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JTCairns
8 - Asteroid
12-24-2019
01:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
brudnicki
7 - Meteor
12-24-2019
06:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hjardine
8 - Asteroid
12-31-2019
05:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
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.
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
01-04-2020
08:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
AlexSa
Alteryx Alumni (Retired)
01-04-2020
07:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
saravanasriram
7 - Meteor
01-06-2020
09:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Solution below
JustinBabbitt
Alteryx
01-09-2020
11:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
mheinze
Alteryx
01-09-2020
03:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
Use of Summarize concatenating strings is key to getting the format with ties in one line.