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 pass default value in filter for between clause

Received Response
1
Views
1
Comments
Chandra M. G.
Chandra M. G. Rank 4 - Community Specialist
edited Aug 13, 2024 5:54PM in Oracle Analytics Forum

Hello,

I am using a filter on "Effective Date" column which is taking start/end date from dashboard prompt with presentation variable.

Now issue is, i want to have some dynamic default values for both start/end date.

Below is the filter which i am using -

pastedImage_0.png

For Default values, it doesn't pick the TIMESTAMPADD function.

So as a Default values, End date should be MAX("Master Mappings"."Effective Date") and Start Date should be (MAX("Master Mappings"."Effective Date") -6) means 6 month earlier one.

Please help to achieve the same.

Thanks

Chandra M.

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics & AI Strategist

    Why not default on your prompts?

    Otherwise, you are currently casting as a date and then treating it as a timestamp, you need to explicitly convert it to a timestamp.

    Not convinced your max requirement is achievable in a default, unless any knows otherwise?