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

Rugile
5 - Atom

Challenge #3 solution

Rugile
5 - Atom

Challenge #3 solution.

Rugile
5 - Atom

Solution example for challenge #3.

DanielG
8 - Asteroid

This was a bit clunky, but I got what I think was being asked for.  (Not what was showing in the output sample, which didnt make sense to alot of people).

 

Hopefully this is ultimately what was being looked for.

 

Will be perusing some other completed samples for more elegant ways to do this, as mine is not slick at all.

 

 

Slacker
8 - Asteroid

My Solution

PHinkel
7 - Meteor

Hi,

 

Attached is my solution.

If anyone is having issues trying to determine what the end result should look like I believe I cross-tab'd the Output they gave us to give a better idea of the end result.

AviratG
6 - Meteoroid

Tools Used: Record ID, Select, Sort, Imputation, Transpose, Crosstab, Join, Multi-row Formula, Dynamic Rename

jfrg125
8 - Asteroid
Spoiler
Screenshot (165).png
ricardocarog
8 - Asteroid

Solution attached.

SadiyaGirach
6 - Meteoroid

Completed