Challenge #3: Running Averages

[Paul-Evans]

I did some further investigation and noticed that "HP Category" is not selected in the r6mo multi-row formula (tool 75) like it was in the r3mo one. 

[nbandla]

My Solution

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[mek201gs]

Doesn't look much like the solution shared but here goes... Multi-Row Formula is def not my fave!

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[JamesMA]

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[sann0638]

Here's my version.  Is the start file still wrong in terms of its output file?

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[ChrisTX]

My first use of Transpose and Cross Tab. Very powerful. Looks like I forgot to use the Imputation tool.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[DavidCJohnson]

Similar to other solutions that I have seen.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Sajeel_Kershi]

Challenge 3 completed -  a bit more challenging then the others.

Struggled a bit to reconcile with the solution. I think the provided solution has an error. On the Multi Formula Tool the calculations need to be grouped by HP Category and by the measure Name. In the provided solution it is for the 3 month average but on the 6 month average it is only grouped by the measure Name.

The other thing I noticed is that its probably not a good idea to have field names with "." in it. Using the crosstab tool it substitutes "_" for the "." which resulted in a mismatch when I tried to reconcile (fixed by renaming the field)

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[joefrazey]

Excited to see how this was actually solved!

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.