Free Trial

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

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

chris_ramsay_dup_425
8 - Asteroid

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.

DriveMyData
7 - Meteor

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

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

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

jssandom
8 - Asteroid

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.

Inactive User
Not applicable

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.

tammybrown_tds
9 - Comet

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.

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

myastarling
10 - Fireball

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.