Free Trial

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: