Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Rugile
5 - Atom

Challenge #3 solution

Rugile
5 - Atom

Challenge #3 solution.

Rugile
5 - Atom

Solution example for challenge #3.

DanielG
12 - Quasar

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
rcarog
8 - Asteroid

Solution attached.

SadiyaGirach
6 - Meteoroid

Completed