Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

Challenge #293: Top 5 Artists

AkimasaKajitani
17 - Castor
17 - Castor

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

 

kelvin_law1
9 - Comet

Here is my solution with table output:

Spoiler


kelvinlaw_0-1636422178025.png
kelvinlaw_1-1636422206691.png
rmassambane
10 - Fireball

=D

TurboToad
10 - Fireball

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
17 - Castor
17 - Castor
Spoiler
Luke_C_0-1636466366987.png

 

DaisukeTsuchiya
14 - Magnetar
Spoiler
キャプチャ.JPGキャプチャ2.JPG

  

Tony_Castillo
9 - Comet

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

Spoiler
Tony_Castillo_0-1636470080298.png