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

How to filter dynamically Oct 204 vs Nov 2024 and Nov 2023 vs Nov 2024 (YTD)

Received Response
31
Views
3
Comments
User_65OG0
User_65OG0 Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Hi ,

I have a column called pro_dte and value inside like this 30/11/2023 12:00:00 am. It will only have last day of the month for all records.

My question is, I have a dataset for pro_dte that contains nov 2023, oct 2024, nov 2024. In first graph im showing MTD so i want to filter only Oct 2024 and Nov 2024 . And in second graph, im showing YTD so i want to filter only Nov 2023 and Nov 2024.

How to do this is OAS server analytical too?

Tagged:

Answers

  • Rajakumar Burra
    Rajakumar Burra Rank 6 - Analytics Lead

    Create two Parameters and bind it in filters.

    image.png

    Filter like this.

    image.png
  • User_65OG0
    User_65OG0 Rank 2 - Community Beginner

    Hi @Rajakumar Burra , It doesn work. Are we hardcoding the month here? I want it to be dynamic. Example at any time it should take the 2 months in the available dataset.

  • Rajakumar Burra
    Rajakumar Burra Rank 6 - Analytics Lead

    I am using it. It works fine for me.

    Create two parameters. Parameters values can be set dynamically with logical expression or pick list.All depends on your business case.

    image.png