Moving averages based on Months — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Moving averages based on Months

edited Feb 22, 2017 9:51PM in Taleo Enterprise 2 comments

Summary

Issue with Moving average using Month Calendar Function

Content

Hi -

We are currently having issues with our reports with moving averages.

With the new year coming in, new months data for the new year is being taken into account (and will also eventually aggregate with previous years months) when calculating for moving averages.

We currently have candidates new hire dates grouped into month using the MONTH function (MONTH("Submission Dates"."Hired Date")).   Since no year is included the system calculates based on chronology of months regardless of year.

Is there a function to classify/group hires based on month per year? (not only month)  This will allow us to come up with unique months per year and allow the moving average to calculate properly/

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!