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

I started this one a long time ago, but never posted because my results didn't quite match. I finally realized that it was an issue with the provided solution! My solution is similar to most of the others.

 

Spoiler

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

Highlighted
Meteor

Took me some time to get this one right.

 


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

Highlighted
Asteroid

Here's my retake on it. This one is a more system resource efficient solution. It is very similar to the official solution.

(My previous solution was much easier to understand but very resource inefficient.) 

 


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
Asteroid

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
Asteroid

Another challenge down. I appreciate the practice for cross tab / transpose tools


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

Meteor

Great example of how a Transpose (Long vs wide dataset) can help simplify the calculation process.


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

Highlighted
Asteroid

this challenge is pretty easy once you know how to use 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.

Highlighted
Asteroid

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

Got very similar to solution, didn't realise multi join exsisted though


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