Challenge #3: Running Averages

[pharaphoks]

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

[mpennington]

Solution attached.

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

[DavidW]

Spoiler

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

[ccruzagosto]

The solution output seems to be a bit off, but I was able to get it to match up.

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

[KatieA]

I have seen more efficient ways to solve this for sure!!

This article helped me in the rolling average: https://www.thedataschool.co.uk/jeremy-kneebone/calculating-moving-average-alteryx/

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

[JeremyN]

Spoiler

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

[Johnny_Analytics]

Spoiler

I'm sure when I check thru the other posts I will see someone use a macro to great effect!  I went the direct route.

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

[SachinKotian]

A bit complicated but got it!

Spoiler

[pengland17]

Hello!

Please find attached my solution to the challenge.

Spoiler

Many thanks,

Paul

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

[DataG8]

Multi-row and dynamic rename. I still couldn't get any exact match for the Expect Equal tool. Not going to let perfect me the enemy of good.

Spoiler

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