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

blairmbailey
Asteroide

Solution attached - thanks!


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

michalsicak
Meteoro

two different solutions. One that scales well and one that would not 🙂

 


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

SGolnik
11 - Bolide
11 - Bolide

I wish I had thought to use the dynamic rename tool LOL I renamed using select tools.


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Pasty
Meteoroide

Done


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

LalaLele66
Meteoro

Done.


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

LalaLele66
Meteoro

Apparently I tried to post multiple times! Oops!

EmanueleE
Asteroide

my solution!

 


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

dominiklz
Asteroide

very ugly, very brute force, but works for me...


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Joren
Meteoroide

~Joren


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

asabau
Asteroide

Here it is. I changed the imputation to add the closest row value (most recent month value) and not 0.


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.