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

mmenth
11 - Bolide

Made a pretty slick macro for my solution:


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

ngrant
5 - Atom

Here is my simple approach, where I just copied and edited the Multi Row formula for each Field.

 

I like the approach in the Official Solution to Transpose and use Dynamic rename, but I agree with other comments about the solution that replacing Nulls with zero is not really accurate.   

 

I think the rolling averages are more accurate using the 'Set to values of Closest Valid Row' option in the Multi Formula tool.

 

 

 cheers

Neil


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

ddiesel
12 - Quasar

My solution:

 


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

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

Dan_Silva
6 - Meteoroid

This one took waaay more time than it was supposed to. Got a better understanding of the Multi-Row formula tool and Average(n-1,n-n) function after solving this. I'm not even mad that other people came up with very similar solutions this time. 

 

Cheers,


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

Pepper
8 - Asteroid

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

ErenErdogan
7 - Meteor

Hello,

 

Here is my solution:

 

Have a great week all,

Eren.


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

cgoodman3
12 - Quasar
12 - Quasar

Seems like I didn't post the yxmd file for this challenge so it's not showing up on the tracker as complete.


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

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
jwlong91
8 - Asteroid

Fun challenge, although I was very confused as to why my output wasn't matching till I saw others' comments.


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

SMSatCFA
6 - Meteoroid

Done!


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