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
Solved! Go to Solution.
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
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!
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?