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
A fun one. Good use of grouping, multi-row, and some creative string manipulation with the formula tool.
Probably not the most elegant solution, but I can't think of a slicker way off the top of my head...
Spoiler
I created a substring formula to chop out the third number of the year, then added a zero and "'s" to create the decade.
I then split the split the stream to take the top 100 and top 10 records, created a count per decade per artist, then determined the max number of each decade and joined back to the stream on ocunt to max-count to isolate those artists with the max count, ie the most in that decade.
I then simply used the concatenate function in the sum tool to smoosh to one line.
I then split the split the stream to take the top 100 and top 10 records, created a count per decade per artist, then determined the max number of each decade and joined back to the stream on ocunt to max-count to isolate those artists with the max count, ie the most in that decade.
I then simply used the concatenate function in the sum tool to smoosh to one line.
M.
