Challenge #293: Top 5 Artists

[AYXAcademy]

A 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]

Some great tunes to check out!

スポイラ

[Blake]

What type of music do balloons fear?

スポイラ

pop music

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

スポイラ

[PhilipMannering]

Garish formatting,

スポイラ

[binuacs]

スポイラ

[RolandSchubert]

スポイラ

My solution

[DataPrepChad]

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

スポイラ

Solution:

And of course our LIVE build:

[DataPrepChad]

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

[alexnajm]

Good challenge!

スポイラ

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]

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

スポイラ