1 of 1 people found this helpful
You have to create data filters like below
First I create a filter date more than 2013
Step-3 Nother formula which date<today()
i'm not clear understood your requirement very well. can you please let me know is there any specify from date and to-date need to fix for entire report..?
If you want fix date then try like this in the data source level as well.
Base on fixed date, i create a calculated field with, with this formula i will get values before 2016-10-10
also less than 1000 days from today dates.
hi Venkatram, thanks for taking the time to respond. Re-reading my post now I think I could have indicated more clearly (though see Title and Tags) that the filter I want to set up is not a Datasource filter but an Extract Filter, to limit the data that is stored in my Tableau Extract (I don't need data for 167 out of the 204 days for which there is data in the table).
However, it was useful seeing your screengrabs as the same syntax applies to the Extract Filter. My mistake was assuming that I could omit the [Date MO] field in the formula. When I bring that in, the filter works.
Note: If i answer helpful to resolve, please mark correct and close this thread.