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

Spurs
8 - Asteroid
Spoiler
Spurs_0-1671816103694.png

 Not entirely sure if my output is the same, some of my figures look a little different but not sure if this is just down to rounding. 

 

flavio-matos
7 - Meteor

My solution

Spoiler
flaviomatos_0-1672308257387.png

 

Minsu
7 - Meteor

Here is my solution!

kristiadiuisan
8 - Asteroid
Spoiler
Spoiler
Alteryx_challenge_3_KU.png

 

isabelcc
8 - Asteroid
Spoiler
3.png

My Solution

alacoume
9 - Comet

My (brute force) solution...

BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

Gave my interpretation of the solution.

 

Note: If the required amount of previous months weren't available to calculate the specified running avg, I assigned the result as null; i.e. if you are in Feb, and only January is available as a prior month, we shouldn't be able to do (Jan+Feb/)2 as that's a 2-month running avg, so I'd assign Feb as a null. Correct me if this assumption is wrong! 🤓

Spoiler
BS_THE_ANALYST_0-1673712399400.png

 

All the best,
BS

LinkedIN

Bulien
Sharod100
7 - Meteor

Hello,

 

Here is my solution to Challenge 3! :) 

Blue1
7 - Meteor

Thank you for the challenge - my solution is attached.

patrickprentice
8 - Asteroid

Hard one for me but I just recently had to do some running numbers at work.  Solution: