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

My (brute force) solution...

BS_THE_ANALYST
13 - Pulsar

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

 

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: