Challenge #3: Running Averages

[enci1017]

Solution to challenge 3, very similar to the posted solution, instead of data imputation, i used data cleaning tool.

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

[Brian6]

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

[awhitacre77]

My solution attached...

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

[paulburrows]

Here's my solution! 

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

[T_Willins]

Working old challenges.  This is my solution.  I think this has been mentioned in the thread, but I think the 6 month averages in the output are calculating incorrectly as they cross categories.  After I finished I looked at the provided solution and found the formula in the Multi-Row Formula (75) tool is looking across categories (first seen at record 73).  This workflow could be simplified if the Multi-Field Formula tool could look back or forward rows like the Multi-Row Formula tool does.  This would swap 12 Multi-Row Formula tools for 2 Multi-Field Formula tools.

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

[tanya_wilcox]

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

[alexm06]

This was an interesting one. 

Here's my solution

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

[KP2]

#3 completed

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

[Aobern]

My solution 🙂

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

[NilsM]

Spoiler

My solution. 

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