Oracle Communities

Oracle Analytics and AI

Child Item

Expression Filters (Dynamic Date Ranges)

Kelvin007

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

Find more posts tagged with

Oracle Fusion Analytics

FDI

Fusion AI Data Platform

Accepted answers

Caroline Blanchard

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?

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!

All comments

Caroline Blanchard

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?

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!

Volodymyr Faranosov

https://community.oracle.com/products/oracleanalytics/discussion/comment/49088#Comment_49088

Hi @Caroline,

Is there a way to dynamically set "Relative to" to the date specified by another filter?

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/74765#Comment_74765

Hi @Volodymyr Faranosov,

As it is more than 2 years old post (and if you are not able to receive any answer), I would recommend you to raise a new question with all relevant details like issue details, screenshot (without sensitive data) etc. so that someone can able to help you.

Thank you.

Juan

Hi!

I’m not sure if I’m too late, but I’ll put here the expression filter that I usually use. It counts the last 12 months, excluding the current month.

"HCM - Workforce Core"."Time"."Month" =VALUEOF(NQ_SESSION.TRAILING_12_GREGORIAN_PERIODS)
AND MONTH < VALUEOF(NQ_SESSION.CURRENT_GREGORIAN_MONTH)

I hope it helps :)

Regards,
Juan