FAW: Can we perform Period Rolling on Ago functions (nested query)

Question

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?

Raghavendra Raghunath-Oracle · Answer

Hi @Simran Jariwala try this sample dv

Raghu

TTM Turnover DV (1).dva

Sumanth V -Oracle · Answer

@Simran Jariwala,

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)