nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Expression Filter to Filter to MAX Date

JobDeLuna

Hi,

Request any help the possibility for an expression filter to filter to the MAX Date.

"SCST - Savings Impact Reporting"."Time"."Snapshot Date"

Find more posts tagged with

Data Preparation and Flows

Filters

Fusion Data Intelligence

Calculation

Fusion AI Data Platform

Accepted answers

Jestin Rajan

https://community.oracle.com/products/oracleanalytics/discussion/27214/expression-filter-to-filter-to-max-date

Hi,

You can use the TOPN function 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.

All comments

Jestin Rajan

https://community.oracle.com/products/oracleanalytics/discussion/27214/expression-filter-to-filter-to-max-date

Hi,

You can use the TOPN function 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.

JobDeLuna

Thanks @Jestin Rajan !!! It worked

Jestin Rajan

Happy to help! 😊