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