Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Rolling Average Based on Dates




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,




Alteryx Certified Partner
Alteryx Certified Partner

@slinky123 ,


Have you found the CReW macros (Download Here) available from


There's a moving Summarize that should help you.




Alteryx ACE & Top Community Contributor

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

Check out the Moving Summarize tool in the CReW Macros:

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!


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?



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