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 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.

Some great tunes to check out!

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.

Garish formatting,

My solution

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:

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

Good challenge!

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?

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?

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