Challenge #3: Running Averages

[Krzysztof_Hyla_1986]

I have modified my answer and used additional tools to tie out to the solutions answer.

Replaced "Data Cleansing" tool with "Imputation" tool

Spoiler

 

[H_a_n_g_C_h_e_n__x3]

There seems to be some inconsistency for finding the running average of month 3 and 6. 3 is grouped by RM Category while 6 is not.  Otherwise, it's a pretty good challenge.

[JD_Billigence]

Were there any issues with the original data? I am working on recreating it and looking into various approaches. However, I can see that much of the original content was removed and replaced with a text file. 

Is it still worth my trying to build a solution using this data? 

[rtshow]

Spoiler

Solution 

 

[pnjoroge]

Suggested Solution for Weekly challenge attached. Mine is pretty manual as I used the multirow formula for each calculation. 

[kmbassett01]

I feel like I fulfilled the prompt, but the goal output file looks completely different.

[Angelica_Obi]

Completed

Took me ages but I learnt something new. I also had to use the solution a little but I did do some things differently as well

[gawa]

Though not exactly same to solution, but this is my answer.

Spoiler

[gawa]

As cannot edit last post, upload solution as a new post

[AImbody]

This was good for some tools I wasn't familiar with.