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
Asteroid

Done

 


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

Highlighted
Asteroid
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

complete


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

Highlighted
Meteor

Here's my solution.  I think I might have gone the long way with renaming columns, but it got the job done!


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

Highlighted
Meteor

Solution Attached! 





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

Highlighted
Meteoroid

Finished


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

Highlighted
Meteoroid

Finished.


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

eww..that took longer than it should have...but it looks like mine is similar to everyone else- so i'm good!

 


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

Highlighted
Quasar
Quasar

number 3  


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

Meteoroid

Attached two solutions. One performs the rolling average using HP and Name, while one only uses Name. The solution provided shows the 3 month rolling average using HP and Name, while the 6 month rolling average only uses Name.


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