Challenge #293: Top 5 Artists

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.

challenge_293_start_file.yxzp

challenge_293_solution.yxzp

Advanced

Data Analysis

Data Preparation

Basic

Accepted answers

All comments

François_Rs

Spoiler

challenge_293_start_file.yxmd

ShankerV

Had the thrill of solving

Here with my solution

Spoiler

challenge_293_start_file.yxmd

RobbieA

293 Solution:

challenge_293_RA.yxmd

akorte1

Done

Tofel

Probably overcomplicated

Spoiler

challenge_293_start_file.yxmd

myastarling

here's my solution.

challenge_293_myajstarling.yxmd

RobertOdera

Here is my solution - cheers!

Spoiler

challenge_293.yxzp

WernerE

My take on this challenge...

Spoiler

challenge_293_start_file_Completed.yxzp

Ed2000

Spoiler

challenge_293_start_file.yxmd

PrachiD

Data Prep, summarize, report text

Submission_293_Data_Prep_Reporting.yxmd

lucaskro

My solution

Spoiler

challenge_293.yxmd

NMangera

Spoiler

my eyes...they hurt...

Spoiler

challenge_293_NM.yxmd

CeliaC_Silje

Spoiler

challenge_293_start_file.yxzp

dougbaron

not bad

Spoiler

challenge_293_final_file.yxzp

Kamran1991

How can I stop receiving the notification, when someone complete this challenge ?

trepryor

top charts workflow.png

challenge_293_start_file_TP_solved.yxmd

ewi7487

Spoiler

Kamran1991

testing post, to avoid the mails. coming once someone completes this challenge

ed_hayter

Spoiler

played around with conditional formatting

challenge_293_start_file.yxzp

Dani_Lin

solved

challenge_293_DML_Solution.yxmd

tristank

What a throwback

Spoiler

challenge 293 completed.yxmd

brrosenau

Spoiler

first time using a table!

challenge_293_br.yxmd

mithily

Spoiler

the question is a little confusingly worded or I am not that familiar with the Billboard but I got there

challenge_293_start_filemili.yxzp

caltang

Added my own flair to it thanks to Coolors!

Spoiler

challenge_293_start_file_caltang.yxmd

AndreeaS

Spoiler

challenge_293_done.yxzp

DanielG

Solved.

challenge_293_finished.yxmd

Carolyn

Completed!

Spoiler

2023-08-24 11_53_45-Alteryx Designer x64 - challenge_293_start_file.yxmd.png

challenge_293_start_file.yxzp

gawa

Done

challenge_293_start_file_gawa.yxmd

olivier_newman

some throw back songs

challenge 293.yxzp

mwong

This challenge really messed me up. I thought I was doing something wrong, but I guess the issue what that the data (and especially the hint!) were misleading. From scanning the solution and some others' solution, the column for "Weeks on Chart" is just wrong and should be ignored apparently. Regardless, here is my solution. I think this addresses the challenge via my interpretation at least.

challenge_293.yxmd

alacoume

Nice for managing table formatting!

challenge_293_start_file.yxmd

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235