Oracle Communities

Oracle Analytics and AI

Child Item

Option to exclude current period from relative date filter

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

EGA

Description (Required):

Option to exclude current day/week/month from relative date filter.

Use Case and Business Need (Required):

At the end of the day/month only our business users make sure of the data accuracy. And also if we are seeing the trend for the last few days and if the current day information is partial we can see a sudden dip.

Enhancement Request / Service Request:

Find more posts tagged with

Planned

Analysis and Data Visualization

Status: Planned

Comments

Deb_Infy

Hi Team,

I am logging behalf of Infosys Limited for one of our client Telenor.

Looking for a response from your end.

Regards,

Debasmita

Gabby Rubin-Oracle

Right now, you can use an expression filter (note that this shows the last 6 months without the current month; change the number if you want more or fewer months):

YOUR_DATE_COLUMN >= TIMESTAMPADD(SQL_TSI_MONTH, -6, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) +1, CURRENT_DATE))

Having the option in the UI is planned.