Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 232 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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.
Tagged:
0