Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #3: Running Averages

kelly_gilbert
13 - Pulsar

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.

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