Hi,
I am looking how we can set the default date filter or limit based on data available like my file started from 1st jan-2020 to 31-dec-2021. My date calendars should not pick other date like 31-Dec-2019
Hi,
I am looking how we can set the default date filter or limit based on data available like my file started from 1st jan-2020 to 31-dec-2021. My date calendars should not pick other date like 31-Dec-2019
Hi @Naveed , you should be able to use the ārelative dateā filter to set the date filter to something like ālast 2 yearsā showing in the screenshot below. In the near future, we will launch a feature called ārolling dateā through which you can setup more specific dynanic date for your time range such āend of last quarterā or āstart of this weekā, etc.
Hi @Naveed , I hope this makes senseā¦you need 2 x filters. 1 x filter for your āUsersā (mine is showing 110 days) and 1 x filter set with āparametersā that is Hidden( this has your in-between ādatesā). Like thisā¦
Create a āStart dateā parameter, Set static ādefaultā dateā¦you said ā2020/01/01ā (in my example Iāve just named it āasofdatestartā)
Create a āEnd dateā parameter, in my example Iāve just named it āasofdateendā. Now set your static āDefault Dateāā¦for your example 2021/12/31.
(I have my parameter End dates dynamically set to ānowā, using GetDate() ā more information on setting up Dynamic parameter defaults here @ 16mins 51sec Dynamic Date Filters with Parameters (and more) in QuickSight - YouTube)
SETUP your 1st filter - āuserā filter (how you would like them to control their view)
NEXT - Add the 2nd filter but this filter is controlled by āparametersā i.e. āasofdatestartā and āasofdateendā
ONLY display your āUserā filter on your dashboard and the āUserā filter will work within your specific dates of your āparameterā filter.
Thanks let me try it
It looking workable let me try it.