community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Rolling Average Based on Dates

Highlighted
Meteor

Hi,

 

In the attached, how do I get Alteryx to replicate the calculations in columns E and F?

 

I want a 12 day rolling average based on the date in column A for both actual and contracted hours.

 

In the future, I need to do the same for an 84 day average so please bear that in mind :-)

 

Thanks a lot in advance,

Scott

 

 

Alteryx Certified Partner
Alteryx Certified Partner

@slinky123 ,

 

Have you found the CReW macros (Download Here) available from http://www.chaosreignswithin.com/p/macros.html.

 

There's a moving Summarize that should help you.

 

Cheers,


Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Asteroid

Check out the Moving Summarize tool in the CReW Macros: http://www.chaosreignswithin.com/p/macros.html

Select the Actual Hours field, use the Average summarize method, make Rows back = 11 and Rows forward = 0. Add the tool again for the Contracted Hours.

 

Someone may have another method but this is a really simple approach!

Meteor

Thanks so much for coming back to me. How would I incorporate the payroll no (as there are going to be thousands of them, all with different hours) in this case?

 

Meteor

Managed to sort this in the end. Thanks for your help!

Labels