Challenge #3: Running Averages

[amanda_payne]

Spoiler

[Gowthamrajas]

Good Solution

[Gowthamrajas]

Solution with Multi Row Tools

[jay_char]

Good Exercise for new tools! Thank you!

[chandler-gjino]

Attaching my solution

[Rain7]

Completed.

Spoiler

[LynnPätzold]

To be honest I was a little confused by the formulation of the question and the form of the giving solution. 

Also running the challenge took a long time, but I fixed it with putting the given solution table into a container and switching it off.

Spoiler

 

[lucascs]

Not 100%, but I couldn't find out why the multi-row formula tool doesn't perform as it seems to be expected from the challenge. Maybe something changed since then? AMP? Does anyone know? On the answer, when the original value was 'null', the tool seems to be taking the closest valid value. Note, this is different than setting the "Values for ROWS that don't exist". Anyway.

Spoiler

[tristank]

Spoiler

I was struggling with this for a minute. At first, was using tiling to separate the categories and names. Realized I just had to group by RM and category and then it worked as intended. Was also trying to create logic for the multirow but I see that the closest values option allows me to divide everything by six and three. Output looks different than the challenge output but their output didn't make sense to me and wouldn't be good for analyzing the data. 

Tough challenge for me but good practice for one particular tool. (Details in spoiler)

[olga_strubbe]

Spoiler

A nice challenge, thank you, @GeneR .  I did use 'Avg' instead of Sum though in the final Transpose tool to get running avg.  Hope this is correct.  Thank you.