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
- 95 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
Expression Filter to Filter to MAX Date
JobDeLuna
Rank 5 - Community Champion
Hi,
Request any help the possibility for an expression filter to filter to the MAX Date.
"SCST - Savings Impact Reporting"."Time"."Snapshot Date"
1
Best Answer
-
Hi,
You can use the
TOPNfunction to get the MAX date. It should do the trick!TOPN(CAST("SCST - Savings Impact Reporting"."Time"."Snapshot Date" AS DATE), 1) = 1
Let me know if you face any challenges while implementing it.
1
Answers
-
Thanks @Jestin Rajan !!! It worked
1 -
Happy to help! 😊
0