Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OAC - Auto selection of Current Date in List Filter

Received Response
12
Views
2
Comments
Hasan Sd
Hasan Sd Rank 5 - Community Champion
in Oracle Analytics Cloud and Server

Hii OAC Community. As shown below ,In some of our visualizations ,We have List Filter having Date values of Data type:Date and Format :dd/MM/yyyy .We want to make sure that the selection of Current Date is done automatically .For this we tried with Parameters ,but we couldn't found the current date value as shown below.Pls suggest if this the correct approach ? also how to resolve this .Thank you.

image.png image.png

Answers

  • Sushant Mishra
    Sushant Mishra Rank 5 - Community Champion

    You’re on the right track by using a date parameter to auto-select today’s date in your filter. For this to work, set your parameter’s initial value to an expression like CURRENT_DATE instead of a hardcoded date. Make sure your dataset always includes today’s date, otherwise the filter cannot select it automatically. If your data sometimes lacks the current date, consider applying a filter expression (YourDateColumn = CURRENT_DATE) or use the Relative Time Filter for best flexibility.

    Hope this helps.

  • RVohra
    RVohra Rank 6 - Analytics Lead

    Can you create a derived column in In your data model / dataset,

    Example:

    • CASE WHEN TRUNC("Your_Date_Column") = TRUNC(CURRENT_DATE) THEN 'Y' ELSE 'N' END AS Is_Today
    • Now add this column to your canvas.
    • Create a hidden filter Is_Today = 'Y' on to limit data to today’s date.
    • Leave the List Filter for date visible, users can still change it manually.