community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #3: Running Averages

Highlighted
Meteoroid

I realize this challenge is several years old now and this has probably been covered, but aren't rows 1–3 of the running three-month average of u.CAGI incorrect? I refer to the output and to the comment box in the Start File, which says that the running 3 month average of 218 and 200 is 212, and that the running average of 218, 200, and 272 is 233:

 

Running average issue.png

Meteoroid

Looks like I renamed the columns the hard way. At least I now know about the dynamic rename tool.

 


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

Asteroid

Not a very elegant solution, but I think it's correct even though the Expect Equal macro shows an error.  

 


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

Meteoroid

Hi there!



As attached is a screenshot of my workflow and the file.

 


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

Alteryx Partner

Managed to tackle this one as well! Didn't came up with converting the data set into long format to make calculating moving averages easier.

 


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

Alteryx Partner

Solution for Challenge 3


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

Alteryx Partner

Solution for Challenge 3

Meteor

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

Alteryx Partner

My solution:

 


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

Meteor

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