Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

How to show upcomig milestone based on date in Canvas

Accepted answer
21
Views
2
Comments
Rajakumar Burra
Rajakumar Burra Rank 6 - Analytics & AI Lead
in Oracle Analytics Forum

I have a table like below.

I want show only upcoming milestone based on current date.

For example, My canvas should show only RC2 Content Complete Oct/25/2024

Any ideas?

image.png

Best Answer

  • Federico Venturin - Oracle
    Federico Venturin - Oracle Mod
    Answer ✓

    Hi @Rajakumar Burra ,

    I would create a parameter and initialize it with the date of the upcoming milestone using a logical SQL query: select MIN(Date) from <Dataset/Subject area> where Date >= CURRENT_DATE and Milestones IS NOT NULL

    Then you can add an expression filter to your table (or to your canvas): Date = @parameter(<NAME>)(<DEFAULT>)

Answers

  • Rajakumar Burra
    Rajakumar Burra Rank 6 - Analytics & AI Lead

    Thanks @Federico Venturin It works.

    In

    I have not used Logical SQL parameter select MIN(Date) from <Dataset/Subject area> where Date >= CURRENT_DATE

    and used Initial Value as "First Available" and bind to table filters.