Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #3: Running Averages

Highlighted
8 - Asteroid

This wasn't very intuitive for me, so I struggled to use the multi-row formulas unsuccessfully a few times before managing to make it work. 


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

Highlighted
Alteryx Certified Partner

Hi,

 

Please find the solution below

 

Thanks,

Chris


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

Highlighted
Alteryx Partner

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

Highlighted
5 - Atom

Bit of a long solution but it worked


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

Highlighted
8 - Asteroid

 

Fun challenge! thanks. Kind of makes you miss a Running Avg.-tool.

 

Some of the solution headers was concatenated and error in r6mo-versions in Multi-Row Formula tool in solution. Looks like missing tickmark in "HP Category"

 


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

Highlighted
Alteryx Certified Partner

I believe there is a mistake in the solution where one of the 'group by's was not used in the multi-row formula for six-month moving average. My solution attached


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

Highlighted
Alteryx Partner

Here's my solution!

Thanks


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

Highlighted
8 - Asteroid

This one was tough.  I ended up using Sean's solution as a tutorial.  Learned a lot, though, even though I didn't solve it on my own.  Here is my solution.


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

Highlighted
Alteryx Certified Partner

My solution:


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

Highlighted
9 - Comet

Here's my solution. Once I got the hang of the multi-field formula tool it was smooth sailing!


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