Challenge #3: Running Averages

[JessieB]

I realize this challenge is several years old now and this has probably been covered, but aren't rows 1–3 of the running three-month average of u.CAGI incorrect? I refer to the output and to the comment box in the Start File, which says that the running 3 month average of 218 and 200 is 212, and that the running average of 218, 200, and 272 is 233:

[bartleb]

Looks like I renamed the columns the hard way. At least I now know about the dynamic rename tool.

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

[Adam_Dooley]

Not a very elegant solution, but I think it's correct even though the Expect Equal macro shows an error.  

Spoiler

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

[ZacPhan]

Hi there!

As attached is a screenshot of my workflow and the file.

Spoiler

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

[Lindsen]

Managed to tackle this one as well! Didn't came up with converting the data set into long format to make calculating moving averages easier.

Spoiler

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

[ConradW]

Solution for Challenge 3

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

[ConradW]

Solution for Challenge 3

[Billigans]

Spoiler

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

[Inactive User]

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.

[Francoisdup]

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