Challenge #3: Running Averages

[JonathanK]

my solution

[mshishido]

My solution

[jennifer_owens]

There has to be an easier, more automated way than what I did here or they would have named these better (3M avg Var) vs Input_#3_var. I look forward to reviewing the answer! 

[jennifer_owens]

Looks like I forgot to make Nulls into 0

[bpiscoya]

Solution approach:

1. Impute the null values per RM category and Year. Despite some solutions impute 0 the temporal series value, I use the median value  

2. Create the moving average for 3 nd 6 months for each requested field

3. Perform the cross tab

PS. if anyone has the spoiler code button, please let me know :)

[PrachiD]

SUbmission for Challenge 3 Alteryx Advanced 

[dougbaron]

this one gives quite a bit of frustration, but I figured it out. It matches the expected output.

Spoiler

The instructions says for Values that do not exist, set values to closest valis row. This, I was assuming was for multi-row formula tool. For 3mo average and 10rm 6mo average, it used just that. For all other 6mo average, it calculated only on the months available and divided by 6. ie single month value divided by 6....2 month values divided by 6...etc.

For sorting, the original data found in the output is sorted to original column order. For 3mo and 6mo averages, they are sorted in alphabetical order.

The origin of the 3mo and 6mo average name are not helpful either.

[dwstada]

had this one sitting around for a few months cause it looked way too annoying

Spoiler

will have to check the official solution, because I doubt this is how it is supposed to be solved

[Alex_Stoica]

Challenge #3 - Solution

[Hammad_Rashid]