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 #3: Running Averages

Dev73
8 - Asteroid

My solution 

Spoiler
challenge 3.jpg
leonardstarrk
8 - Asteroid

Honestly I didn't understand this challenge even after looking at the solution file. Had to see other users' solutions to understand what the challenge actually was about.

Even now I'm still a bit confused.

DaisukeTsuchiya
14 - Magnetar
Spoiler
スクリーンショット 2024-03-24 093210.png
jgvillalta
6 - Meteoroid

My solution.

msobyjr
6 - Meteoroid

they betta recognize

Ed2000
8 - Asteroid
Spoiler
Screenshot 2024-04-24 150346.png
CE_5085781
6 - Meteoroid

Found this one very difficult, especially given the target output, which is not what I would have used/done.

I ended up creating a different output view, leaving the Category as a Column and adding the running averages as extra columns at the end.

Creating separate columns for 3M and 6M averages, perhaps I didn't understand the question?

Spoiler
Screenshot 2024-04-25 171244.png
barrymoe
7 - Meteor

Needed to cheat on this one. 

Bobbyt23
12 - Quasar

Interesting this one and not as straightforward as I first thought.

 

Spoiler
Took me a bit of time to get my multi row calcs right. One day I'll remember the difference between crosstab and Transpose too, without having to look at the images 🤣
Selasi
7 - Meteor

🏁