Categories
- All Categories
- Oracle Analytics Lounge
- 13 Oracle Analytics Technical
- 182 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 Oracle Analytics Trainings
- 14 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
FAW: Can we perform Period Rolling on Ago functions (nested query)

Simran Jariwala
Rank 1 - Community Starter
Hi,
We have a requirement to find Retention rate in HCM Analytics for a client. we have build up the logic for the same but for creating the necessary calculation we require to perform period rolling (summation of 12Months Value) on ago function (here value refers to previous 2Y) in Oracle Analytics Cloud Data Visualization (workbook). Is there any way to achieve that?
0
Answers
-
Have you tried this approach of creating one calculation for AGO function first and then using it in Periodrolling.
E.g: Calculation 1 --> AGO(here value refers to previous 2Y)
Calculation 2 --> PeriodRolling("Calculation 1" , -2, 0)
0 -
0