Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

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 #datautomation
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
8 - Asteroid

spingili_0-1636393584821.png

 

joelmiller66
9 - Comet
Spoiler
Challenge 293 Image.png
TonyA
Alteryx Alumni (Retired)

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
16 - Nebula
16 - Nebula

Solution in the Python Tool,

Spoiler
PhilipMannering_0-1636396274773.png

 

dYoast
11 - Bolide

Another one done.

Spoiler
dYoast_0-1636398046639.pngdYoast_1-1636398062652.png

 

KarenYL
8 - Asteroid

Screenshot 2021-11-08 113246.png

phottovy
13 - Pulsar
13 - Pulsar

I definitely overthought this one at first:

Spoiler
293.png

293 Table.png