Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
PeriodRolling Function is not working
Summary
PeriodRolling Function is not working
Content
There is another thread about this without an answer. Trying to use PERIODROLLING to calculate the total number of terminations over the past 12 months. The documentation does not make sense and is very limited. I noticed that whatever I do to the X and Y parameters, the same number comes up:
PERIODROLLING (measure, X,Y) where typically, X is negative and Y is positive.
My understanding is that X goes back a number of periods and Y is where it stops. Can X be Zero to represent current period? Very unclear unless someone has insight please?
Answers
-
This displays the number correctly over the entire time period but changing the x and y does not change the result of the formula:
I could change the -7 and 7 to any number and there is no change.
0