Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #3: Running Averages

Highlighted

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.

Highlighted
Asteroid

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.

Highlighted

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.

Highlighted
Asteroid

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.

Highlighted
Alteryx Partner

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.

Highlighted
Meteor

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

Highlighted
Meteor

Hi,

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

Regards,

Patrick Fredin

 

 

 


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

Alteryx Partner

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.

Highlighted
Meteor

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.

Highlighted
Asteroid

My solution

 


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