This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
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.
Fun challenge as usual, and more Reporting tools! Our solution below, as well as our live build on YouTube.
And of course our LIVE build:
Good Challenge... Hope Atleast this reply gets flagged as my First Solution... Happy that I can see my Name on 1st or 2nd Page... 😂