Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 96 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Year Over Year Comparison Calc for Custom Subject Areas
Quinn Thacker
Rank 3 - Community Apprentice
Trying to take revenue amounts and create a calculation and dynamic filter that allows you to take a filter selected period and compare it to a trailing period either MoM or YoY.
The native functions like AGO do not work with the custom subject areas we have developed.
Tagged:
0
Answers
-
If you have an proper time dimension , AGO Function should work.
I am not sure below is work for you but for your reference we have one MOS doc related to time series .
FDIP: Inconsistent Values Returned When Using YTD And AGO Across Reports (Doc ID 3011686.1)
Regards,
Arjun
0 -
Hi Quinn,
Under some circumstances, there are alternatives to using the AGO function or Time Series Functions. Filter functions have some advantages including performance as described here:
Regards,
John
0
