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

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

Asteroid

Solution attached.

 

MP 3.png


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

Alteryx
Alteryx

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

David Wilcox
Senior Software Engineer
Alteryx
Meteor

The solution output seems to be a bit off, but I was able to get it to match up.


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

Alteryx
Alteryx

I have seen more efficient ways to solve this for sure!!

 

This article helped me in the rolling average: https://www.thedataschool.co.uk/jeremy-kneebone/calculating-moving-average-alteryx/

 

 


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

Meteor

 

Spoiler

 

 

 


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

 

 

 

 

 

 

I'm sure when I check thru the other posts I will see someone use a macro to great effect!  I went the direct route.


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

Meteoroid

A bit complicated but got it!

 

Spoiler
Capture.JPG
Meteoroid

Hello!

 

Please find attached my solution to the challenge.

 

Spoiler

 

Many thanks,

 

Paul


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

Asteroid

Multi-row and dynamic rename. I still couldn't get any exact match for the Expect Equal tool. Not going to let perfect me the enemy of good.


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