We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #293: Top 5 Artists

AYXAcademy
Alteryx
Alteryx

image_top5.PNGA solution to last week's challenge can be found here.

 

The Billboard (magazine) is a weekly American music and entertainment magazine that provides music charts. The Hot 100 lists the 100 most popular songs of the week in the US.

 

This dataset contains information about the Top 100 most popular songs between 2015 and 2021. Find out the top 5 artists and songs who stayed on the chart the longest (weekly) for each in 2017, 2018, 2019, 2020. Then create a table in the format of your choice to display your results.

 

Hint: The column "Weeks on Chart" shows how many weeks the song was on the charts since its launch.

Aaron_Harter
11 - Bolide

Some great tunes to check out!

Spoiler
0.PNG
Blake
12 - Quasar

What type of music do balloons fear?

 

Spoiler
pop music

Blinding Lights really dominated 2020. I just created a boring chart, I might take another run at it later.

 

Spoiler
293SS.png

 

PhilipMannering
14 - Magnetar
14 - Magnetar

Garish formatting,

 

Spoiler
PhilipMannering_0-1636384753707.png

 

 

 

binuacs
9 - Comet
Spoiler
binuacs_0-1636386965365.png

 

RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
293.jpg293R.jpg

My solution

DataPrepChad
10 - Fireball

Fun challenge as usual, and more Reporting tools!  Our solution below, as well as our live build on YouTube.  

 

Spoiler
Solution:
DataPrepChad_0-1636388048177.png


And of course our LIVE build:

DataPrepChad
10 - Fireball

@Blake  and @RolandSchubert, nice grouping!  This is a huge value for the reporting tools!

alexnajm
8 - Asteroid

Good challenge!

Spoiler
challenge_293_start_file_Alex Abi-Najm.PNG
Annoying with all of the column rules - any way to group by a column and set a color palette similar to the Report Map tool?
allwynthomas24
8 - Asteroid

Good Challenge... Hope Atleast this reply gets flagged as my First Solution... Happy that I can see my Name on 1st or 2nd Page... 😂

 

Spoiler
allwynthomas24_0-1636388509035.png