Challenge #3: Running Averages

[dharini]

This wasn't very intuitive for me, so I struggled to use the multi-row formulas unsuccessfully a few times before managing to make it work. 

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

[chris_ramsay_dup_425]

Hi,

Please find the solution below

Thanks,

Chris

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

[DriveMyData]

Spoiler

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

[Viktor2]

Bit of a long solution but it worked 🙂

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

[MarMu]

Fun challenge! thanks. Kind of makes you miss a Running Avg.-tool.

Some of the solution headers was concatenated and error in r6mo-versions in Multi-Row Formula tool in solution. Looks like missing tickmark in "HP Category"

Spoiler

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

[jssandom]

I believe there is a mistake in the solution where one of the 'group by's was not used in the multi-row formula for six-month moving average. 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.

[Inactive User]

Here's my solution!

Thanks

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

[tammybrown_tds]

This one was tough.  I ended up using Sean's solution as a tutorial.  Learned a lot, though, even though I didn't solve it on my own.  Here is my solution.

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

[Wouter]

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.

[myastarling]

Here's my solution. Once I got the hang of the multi-field formula tool it was smooth sailing!

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