Challenge #3: Running Averages

[kelly_gilbert]

I started this one a long time ago, but never posted because my results didn't quite match. I finally realized that it was an issue with the provided solution! My solution is similar to most of the others.

Spoiler

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

[dvsrtns]

Took me some time to get this one right.

Spoiler

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

[Mausam]

Here's my retake on it. This one is a more system resource efficient solution. It is very similar to the official solution.

(My previous solution was much easier to understand but very resource inefficient.) 

Spoiler

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

[cwatters]

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

[pjdit]

My solution

Spoiler

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

[DataKyle]

Another challenge down. I appreciate the practice for cross tab / transpose tools

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

[Rant]

Great example of how a Transpose (Long vs wide dataset) can help simplify the calculation process.

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

[hfanda73]

this challenge is pretty easy once you know how to use Multi-Row-Formula tool.

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

[Ozzy_Campos]

Solution attached. 

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

[lordoforange]

Got very similar to solution, didn't realise multi join exsisted though

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