Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
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

kelly_gilbert
11 - Bolide

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.

dvsrtns
7 - 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.

Mausam
8 - 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.

cwatters
7 - Meteor

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

PJDit
8 - 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.

kyledunn
8 - 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.

Rant
7 - 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.

hfanda73
8 - 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.

Ozzy_Campos
8 - 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.

lordoforange
7 - Meteor

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.