Challenge #3: Running Averages

[msicak]

Two solutions - one quick and non-scalable, the other long-winded and scalable 🙂

Spoiler

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

[ipeng]

Solution Attached.

I really like the way on comparing output vs. the output file in the solution workflow.

One thing I found out in the output provided in this challenge: 6 month running average is not grouped by HP category. 

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

[AJauniskis]

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.

[paul_houghton]

Working through the backlog

Spoiler

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

[hugolees]

Spoiler

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

[catarina_pimpao]

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.

[EW]

Here's my solution!  I think I have an extra tool or two, but it could have been worse!  

Spoiler

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

[Jemma]

My Solution with fixed average for less than 3 results for 3 month average, and 6 results for 6 month average.  (1+2)/2 instead of (1+2+2)/3

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

[CristianaFerro]

Hi there! I think you solution is great, but try to "Group By" also the multi-row formula for the 6months Average. The Value of those columns are not equal to the output solution.

I was obtaining the same error.

[CristianaFerro]

Hi! My solution..working for the core exam... 🙂 

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