Categories
- All Categories
- Oracle Analytics Learning Hub
- 17 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 84 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
Operations between rows #OBIEE 12C

User_15J6I
Rank 5 - Community Champion
How can I divide a metric from the current month between the previous month or the previous record in obiee 12c?
0
Answers
-
Have a look at the time series calculation functions, for example AGO(...) will let you access the previous month measure value.
The concept of "previous record" is very vague as a previous record always depend on the sorting applied to your analysis, so I would try to stick with something more defined like "previous month" (assuming you have a proper time dimension configured providing a clear definition of "previous month").
0