Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

Thank you Gianni - you made my day ☺️

in How to filter to see only rows where the ID has the newest Date? Comment by User_Y73CE Jan 12, 2022 3:44PM
Thank you Gianni. Perhaps you can give me another hint? I did at a new column with this Column formula: RANK("Date") then i get 1,2,3,4 and 5 in the cells. I don't quite get how to insert the "by ID" expression without error: RANK('Date') BY 'ID' does not work and gives Syntax Error RANK('Date') FROM 'ID' does not work and…

in How to filter to see only rows where the ID has the newest Date? Comment by User_Y73CE Jan 12, 2022 7:09AM