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
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
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. 😁
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
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
Any weekly challenge where I learn something new is a good one! First time adding a bar chart to a table.
