Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

Expression Filters (Dynamic Date Ranges)

Accepted answer
81
Views
1
Comments
Kelvin007
Kelvin007 Rank 1 - Community Starter
edited Aug 13, 2024 7:42PM in Oracle Fusion Data Intelligence

Hi,

does anyone know if it is possible to create expression filter with dynamic date ranges in FAW?

i am trying to create a filter that only shows the "last 12 months", "last 6 months" .. etc from the current date.

any guidance would be much appreciated, thanks

Tagged:

Best Answer

  • Caroline Blanchard
    Caroline Blanchard Rank 6 - Analytics Lead
    Answer ✓

    Hello, not sure if this has been answered by now, but have you seen the relative time feature in either fiscal date or date fields?

    image.png

    I'm sure you could also create an expression filter using 'timestampdiff' with current date if you want to do it manually. Hope this helps!