Challenge #3: Running Averages

[bklninjah]

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]

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]

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]

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]

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]

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]

Spoiler

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

[pionut]

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]

Spoiler

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

[nikolaskardasis]

Spoiler

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