Challenge #3: Running Averages

[PhilipMannering]

Spoiler

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

[nick_ceneviva]

I was putting this one off for a while... Great challenged.  Solution attached.

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

[Suzanne]

Great challenge.  Did it twice to try to cement the learnings. 

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

[derekbelyea]

No points for style... but got the job done.

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

[dheerajpoojari]

My solution attached

Spoiler

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

[Lorna_Eden]

Mulit-Row is so powerful in Alteryx. Potentially my favourite tool

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

[jamielaird]

This feels a bit scrappy but it does the job.  Solution attached.

Spoiler

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

[JacobR77]

Completed!

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

[BenMoss]

Think I over egged this one but it works.

Spoiler

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

[MaxGiegerich]

Phew... Went down the path of calculating each separately then quickly backtracked. Would have worked in fairness but much more time consuming and prone to errors. Great exercise exposing a useful trick!

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