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

Question

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?

Rajakumar Burra · Answer

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.

User_65OG0 · Answer

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 · Answer

Create two Parameters and bind it in filters.

Filter like this.