Challenge #3: Running Averages

[mark-spain]

My solution attached:

Spoiler

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

[Kaviyarasan_P]

I have completed Challenge 3

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

[Awesomeville]

My solution for Challenge #3.

Possibly not the most efficient manner for running dozens of varied averages, but probably the simplest to understand.

Cheers,

Nick

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

[bkclaw113]

Not a fan of this challenge, the result set we are working toward truncates the metrics names at 11 characters.  I also fundamentally disagree with replacing the NULL values with zero before calculating the moving average.  Any time I have worked with moving averages in the past I always respect the NULL and back it out of the denominator for the average.  Those issues aside I did like the practice working with the multi-row formula's.  The ability to do row level operations in Alteryx as opposed to just the traditional set level operations is a big bonus. 

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

[Shifty]

This is my second attempt, after I realised I could use transpose & cross tab to make this a lot quicker. 

My first attempt used a multi-row formula to create each of the 12 monthly average columns!  After the 7th one, it began to look like madness and I went back to the drawing board.  Sadly, I think it would've been quicker to continue with the MRFs because it took my a while to work out the transpose/cross tab configs but I'll know for next time so all worth it in the end.  I also agree that the official solution does not calculate the averages correctly for the first rows. Am I still typing? 

OK here is the solution, sorry:

Spoiler

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

[Ziggy77]

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

[pfredin]

Hi,

Maybe it's not the more efficient solution but it works 😊.

Regards,

Patrick Fredin

Spoiler

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

[vizwiz]

Spoiler

Nice challenge! I'm surprised Alteryx doesn't already have a moving average tool amongst the transform tools.

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

[mgcarrenard]

Solved using multiple Multi-Row Formula tools

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

[Eleonora]

My solution

Spoiler

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