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

AkimasaKajitani
15 - Aurora

My solution.

 

Spoiler
AkimasaKajitani_0-1636416401541.png

AkimasaKajitani_2-1636416721118.png

 


 

 

bdanberg
5 - Atom
Spoiler
bdanberg_0-1636418468562.png

 

For a little flavor, I created a bar chart. Wish Alteryx would let you create a legend by bar color.

Spoiler
bdanberg_1-1636418635798.png

 

kelvinlaw
8 - Asteroid

Here is my solution with table output:

Spoiler


kelvinlaw_0-1636422178025.png
kelvinlaw_1-1636422206691.png
rmassambane
9 - Comet

=D

TurboToad
5 - Atom

Fun learning about the reporting tools. 

 

Spoiler
Spoiler

TurboToad_0-1636429304316.png

 

Rupal03
8 - Asteroid

This was fun!! 

 

My Solution is here...


@AYXAcademy wrote:

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.


Rupal03_0-1636442745250.png

 

rafaaelgeo
6 - Meteoroid
Spoiler
rafaaelgeo_0-1636453578297.png
Luke_C
14 - Magnetar
Spoiler
Luke_C_0-1636466366987.png

 

DaisukeTsuchiya
12 - Quasar
Spoiler
キャプチャ.JPGキャプチャ2.JPG

  

Tony_Castillo
8 - Asteroid

I found different results when finding artists and songs who stayed on the chart the longest (weekly):

Spoiler
Tony_Castillo_0-1636470080298.png