Hi Team,
I have one dashboard, in that dashboard contains date global filter, whenever reset the filter it will shows the “this year” date period as a default, but my end users’ requirement is they wants to see last 12 months as the default date period filter.
So could you please help me to set 12 months as a default date period in filter control.
Thanks & Regards
Chaitanyakumar N
Hi @Cnagabhairava,
Standard filters do not allow you to assign default values, parameters are the tools available to assign defaults. Currently, the only control option for a datetime parameter is a date picker, so there is a work around you can use in this situation, however the control will appear different.
Setup your parameter with the default value as prior 12 months:
Then, setup a second datetime parameter with a default set to ‘Today’.
Now when creating your filter, set a ‘date and time range’ filter type and assign parameters:
In above, my parameter ‘Date’ is the 12 months prior, and ‘Date2’ is set to default of Today.
Last step, add a control from your original ‘Date’ parameter.
Note, If you want to give your user the preference of a date range, you can controls for both date parameters, or you can just leave the second one out so that the ‘end date’ always runs through today or yesterday.
Additional parameter control options for date fields, including relative date options would be really helpful though so I’ll also mark this as a feature request to promote visibility to the support team.
