Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
New Custom Metrics Using PeriodRolling Time Series Function on HCM Measures
Ravi Guddanti-Oracle
Rank 4 - Community Specialist
Content
Use PERIODROLLING time series function in OAC for computing metrics such as "12 Month Rolling Resignation %" or "12 Month Rolling - Total Terminations". PERIODROLLING function (PERIODROLLING(measure, x [,y])) computes the aggregate of a measure over the period starting x units of time and ending y units of time from the current time.
Import the attached dva project file into your OAC instance of Fusion HCM Analytics and explore the custom calculations of the project.
0