Challenge #3: Running Averages

[mmenth]

Made a pretty slick macro for 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.

[ngrant]

Here is my simple approach, where I just copied and edited the Multi Row formula for each Field.

I like the approach in the Official Solution to Transpose and use Dynamic rename, but I agree with other comments about the solution that replacing Nulls with zero is not really accurate.   

I think the rolling averages are more accurate using the 'Set to values of Closest Valid Row' option in the Multi Formula tool.

 cheers

Neil

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

[ddiesel]

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.

[Nmetzgen1]

solution attached

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

[Dan_Silva]

This one took waaay more time than it was supposed to. Got a better understanding of the Multi-Row formula tool and Average(n-1,n-n) function after solving this. I'm not even mad that other people came up with very similar solutions this time. 

Cheers,

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

[Pepper]

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

[ErenErdogan]

Hello,

Here is my solution:

Spoiler

Have a great week all,

Eren.

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

[cgoodman3]

Seems like I didn't post the yxmd file for this challenge so it's not showing up on the tracker as complete.

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

[jwlong91]

Fun challenge, although I was very confused as to why my output wasn't matching till I saw others' comments.

Spoiler

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

[SMSatCFA]

Done!

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