Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a dashboard with date, month and year filter.
I need to show current month data by default, without applying filter.
How can I implement this using "default selection" extension.
what expression I need to write?
for date,month and year filter I am using a common field as D1 which is in the format dd-mm-yyyy.
Pls help me out.
Thanks
Hi Jayati,
you will require SIMPLE FIELD SELECT extension
Steps required
1)and a new column or field text(Date(D1,'MMM YYYY')) as Monthname needs to be created in script
2)and in default selections options
Add the below expression
=TEXT(Date(today(1),'MMM YYYY'))
Regards,
Bhargav