Challenge #3: Running Averages

[rahmed]

Was going to use the transpose tool to be able to one expression, however i felt doing multiple formulas allowed me to make sure the averages were accurate 🙂

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

[Parul_Kapoor]

Solution attached.

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

[damc]

Here´s my solution. Today´s new discovery: the Dynamic Rename tool.

These challenges are a great way to learn!

Spoiler

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

[Dazzerman]

Spoiler

An enjoyable exercise.

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

[MilindGadhia]

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

[shahryal]

Spoiler

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

[Yoyo_Master]

Great intro to the Multirow tool!

Spoiler

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

[JennyMartin]

Spoiler

Good practice for building a batch macro - as an extra challenge!

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

[Assaf_m]

Solution attached 🙂

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

[Normster]

I took a few liberties with this one.  First, I removed all the rows with Nulls all the way across rather than impute the data.  (The total number of rows removed was relatively small).  Second, I organized the fields so that each category was grouped together, e.g., all fields with u.CAGI, d.CAGI, etc.

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