Challenge #3: Running Averages

[cgoodman3]

My solution

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

[EricWe]

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

[jdemeaux]

simple is better

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

[Y-L]

My solution below. 

The Alteryx solution is much faster with the "set value to closest valid row" and the transform tools.

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

[DataHabanero]

Super fun excercise. I decided to batch run the averages. This is a particular excercise in which there are a thousand ways to achieve the same result.

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

[Alekh]

Spoiler

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

[rachelgatto]

Solved.

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

[MitchKibble]

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

[ctrl_kudorje]

Quite similar to other users as posted. However I am happy to see how other Alteryx users have come up with their solutions and learn so many ways to solve a problem 🙂

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

[DiegoParker]

Done! I need to review the way to do it with the macro though. Learnt it before but already forgot, oops!

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