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

bklninjah
7 - Meteor

A little tricky due to NULL values and not grouping by month and year.


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

gradyjofficial
8 - Asteroid

my solution

 

first time using imputation tool!


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

ChrisMelck
8 - Asteroid

I was confused by the moving average example given in instructions...the three numbers given divide by 3 does not equal the moving average supplied as the example answer.

 

Month: Value: Running 3 mo. Average:
1 218 218
2 200 212
3 272 233

 

218+200+272 = 690 / 3 = 230 (not 233)

 

I am fairly pleased with my answer from an eloquence perspective. Would love for someone to give it a look over, but seems to be producing the correct output.

 

Originally was doing multiple multi-row formulas, but the transpose then cross tab approach worked pretty well.


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

aiahwieder
8 - Asteroid

Good intro to multi-row/group by tool.


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

dpuls
7 - Meteor

My solution to number 3.  Two joins at the end for clarity of flow.  


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

cplewis90
13 - Pulsar
13 - Pulsar

Finally posting some of my solutions! This was a really fun one! 

Spoiler

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

prislam
8 - Asteroid

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

pionut
5 - Atom

Hi,

Below is my solution for Challenge 3.

Cheers,

IP


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

juansagasta
7 - Meteor

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

nikolaskardasis
8 - Asteroid

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