Challenge #3: Running Averages

[GeneR]

We hope you enjoyed last week's challenge. For the third challenge, let’s look at creating 3 and 6 month running averages.

The goal is to create 3 and 6 month running averages for the values contained in columns: c.LK98, p.LK98, c.1K, p.1K, c.NLP3, and p.NLP3. Create the averages by RM Category. 

Update: As of 9/20/19, the start and solution files were updated.  Your solutions may not look like those posted by Community members prior to this date. 

[Jemma]

Thank you for the pick up good luck with the study

[DavidThorpe]

The Null values in the output data threw me off for a while, but a good use of the multi-row formula tool.

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

[Badger]

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

[KeithTroutt]

good challenge

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

[RolandSchubert]

My solution. 

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

[Anastasiia]

Hi @GeneR, 

There is a mistake in example presented in Alteryx flow. Instead of 233 there should be 230. Would you be able to correct? 

BR,

Anastasiia 

[Tom_Luthi]

solution attached.

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

[Nicholas_Bowskill]

A little different where the null sections are, however it makes sense to me to have it a null value when null entries are made.

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

[kexelby]

My solution to this weeks challenge! 

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

[Anastasiia]

My solution is here

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