Challenge #3: Running Averages

[Paul_Cornmell]

Struggled with this one and didn't get all my output columns to match the model answer 😞

Spoiler

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

[archietao]

My solution. Not the smart one. 

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

[pdx]

I totally cheated- but learned a bunch. These challenges are great for learning!

[Mac]

I did it brute force (attached) and then took a look at the solution... Love doing these and learning of new ways.

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

[Karam]

Great practice!

Spoiler

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

[joona_rauhamaki]

Here is my macro solution!

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

[catherineduffy]

My solution - quite similar to most others with multiple Transpose tools rather than multiple Cross Tabs

Spoiler

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

[ulrich_schumann]

Changed some column names to make fields (for me) more understandable.

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

[TomE]

Good challenge!  I ran into an issue that many others mentioned, the 6 month running averages in the solution don't always match mine unless I group by Name only (not HP category) in my multi row formula.  I can't think of a good reason why that would be omitted so I assume it's an error...

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

[brandnewday]

Brute force solution:D

In the output, only 3 months average is grouped by HP Category, but here both 3 and 6 months averages are grouped (to align with the task).

@GeneR 

In both output and solution 6 months average is not grouped by HP Category, should it be grouped?

Spoiler

EDIT: in the final row, please read comment as "6 months average" instead:)

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