Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

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.