Organization Name:

Bluebell

Description

User want to set the default filter value as current date (YEAR/MONTH)

but there is no possible way to do it now.

Dashboard Filter -Filter Control-Default Value: Option 'First in List' , 'Custome', 'None'

It would be great if we can choose 'Last in List'

Use Case and Business Need

Issue :

User want to set the default filter value as a current date (YEAR/MONTH)

I tried to use 'Dashboard Filter -Filter Control - Parameter Binding '

and I tryed few workarround like below. but failed

1. I used Parameter binding : 'Current DateTime' —> It does not fit the value for the YEAR/MONTH

(It would be great if we can select current 'YEAR' or current 'YEAR/MONTH' for the default parameter)

2. So, I made a custom paramter using this "

SELECT MAX(
XSA('sckim@bnicorp.co.kr'.'Daily_Nationality')."VIEW_DAILY_NATIONALITY"."YEAR/MONTH")
FROM XSA('sckim@bnicorp.co.kr'.'Daily_Nationality')
ORDER BY 1 DESC NULLS LAST
FETCH FIRST 500001 ROWS ONLY

—> Value is matched well but the displayed value is like "04/01/2024 12:00:00 AM". but My expectation is '2024-04'

So, I suggest the simplist way to satisify the user requirement by adding Option 'Last in List' in Dashboard Filter- Default Value

Thanks