Oracle Analytics Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI Labs› Oracle Analytics Idea Lab

Categories

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

Option to exclude current period from relative date filter

Planned
62
Views
2
Comments
K R Mohan
K R Mohan Rank 2 - Community Beginner
in Oracle Analytics Idea Lab

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:

Tagged:
5
Up
5 votes

Planned · Last Updated

Comments

  • Deb_Infy
    Deb_Infy Rank 2 - Community Beginner

    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
    Gabby Rubin-Oracle Admin

    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.