I have graph where I am using date dimension as a filter and columns , my date filter is set to "Month to date" see attached snap shot , but I want to always exclude today's date , I mean if i run the run the report on Jan 2 then I want to exclude Jan 2 but show Jan 1 , If I run report on Jan 3 then I wan to see date from Jan 1 and Jan 2 but exclude Jan 3 .
How can I do this ?
Is there an option but which I can exclude today date ?
Arif, create a calculated field like this:
[Date]<TODAY()
And place this on the filter shelf, setting it to TRUE.
GK
Become a Viz Whiz on the Forums! Support the Community and master Tableau.