I am working for dynamic date requirement. when every user open the dashboard, date column need to filtered for the particular month...
If user open the dashboard in January 15 then date need to be filtered from 01-Jan-16.
Opens in Feb Month date need to filtered by 01-feb-16
Opens in March Month date need to filtered by 01-Mar-16.
Please help in getting the calc filed.
Its simple. Assuming DATE_COLUMN as your date column
Create calculated field as
DATE_COLUMN = DATETRUNC ('month',TODAY ())
and place it in the filter shelf. Set the value of the filter to 'TRUE' and you are done.