Challenge #3: Running Averages

[Chirag09goa]

very interesting although I am yet to understand the purpose of dynamic rename from the ideal solution. Have completed without that

[scullen]

I don't see where the output file shows a 3 and 6 month running average, or how it matches the example. Confused

I've done my own solution showing 3 Month Avg and 6 Month Avg - not as complex as the posted solution but does the job.

Good way to learn the Multi-Row Formula tool

[Lucatelli]

Attached my solution.

[cody_rush]

Spoiler

[FredNajjar]

Spoiler

[balajilolla]

Spoiler

Spoiler Solution Attached

[JeremyGonzva]

Got there in the end

[deepaprash]

My interpretation of the ques and how I might want to present it.

[KGS]

Hi

The tools used to complete the assignment; Transpose , Imputation (could use data cleansing as well), Multi row field with Average formula using Grouping.

Best,

G

[hieu_hoang]

This is my workflow.