Skip to main content

I want to add the following values to the "Date Selector" tableau parameter

 

(Today, Yesterday, This Week, Last Week, This Month, Last Month, This Quarter, Last Quarter, This Year, Last Year, Year to Date, Previous Year to Date, Previous Month to Date, Custom Range.)

 

Could someone kindly assist me with the several tableau calculations required to produce this output?

 

An example dataset is attached for your use.

 

 I discovered various formulae when browsing the tableau forums, but I can't seem to find a viable method for creating the "Date Selector" parameter. I've attached the formulas I found here as well.

 

For the sake of our customer, I'm attempting to mimic the date filter features of another program and include those in tableau reports.

4 answers
0/9000