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

sara_burk
7 - Meteor
Determine the five songs from 2017-2020 who were on the Hot 100 most frequently, then create a chart in Alteryx#weeklychallenge#alteryx#datascience#datautoma...
AlexvanOs
8 - Asteroid

My solution:

Spoiler
I don't quite get the hint, as the used solution doesn't seem to use that field, so I implemented a report that shows a table that does make use of it and a table with the sample outcome.  😁

293-1.png
Funny to see how 2019 changes quite significantly based on the method used. 

My flow is a little bit more complicated because of that. but still not that hard. Top summarizes on max weeks in chart to give an overall best hits based on overall weeks in the charts, bottom counts IDs to get to the sample output solution that shows the hits that stayed in the charts within a particular year the longest

  293-2.png
jferrone
8 - Asteroid

Happy Monday! I completed the challenge and attached my solution. 

 

Spoiler
jferrone_0-1636391701823.png

 

spingili
6 - Meteoroid

spingili_0-1636393584821.png

 

joelmiller66
8 - Asteroid
Spoiler
Challenge 293 Image.png
TonyA
Alteryx
Alteryx

Any weekly challenge where I learn something new is a good one! First time adding a bar chart to a table.

Spoiler
TonyA_0-1636396022144.png

 

PhilipMannering
14 - Magnetar
14 - Magnetar

Solution in the Python Tool,

Spoiler
PhilipMannering_0-1636396274773.png

 

dYoast
8 - Asteroid

Another one done.

Spoiler
dYoast_0-1636398046639.pngdYoast_1-1636398062652.png

 

KarenYL
8 - Asteroid

Screenshot 2021-11-08 113246.png

phottovy
12 - Quasar

I definitely overthought this one at first:

Spoiler
293.png

293 Table.png