Oracle Analytics Forum

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

Categories

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

How to make only current week data visible in the below format

Received Response
11
Views
2
Comments
3174977
3174977 Rank 5 - Community Champion
edited Aug 13, 2024 6:16PM in Oracle Analytics Forum

Hi All,

I have a requirement where I need to show only the current week data visible and if there are any weeks available that should also display but not any past data.

c1.JPG

The highlighted dates data should not be visible in my report..only current week and the other dates that are available should be only visible. How to achieve this ?

Thanks !

Answers

  • 1008490
    1008490 Rank 3 - Community Apprentice

    Hi,

    Try to find out week number using Date and add a week filter.

  • 3174977
    3174977 Rank 5 - Community Champion

    Hi,

    How can I apply filter ? Because whenever the user runs the report it should display only that current week and after that but no anything before the SYSDATE..

    Thanks !