I want to check the current selected parameter and year
then if if equals to current selected parameter and year then for last year MTD also select till yesterday data
Eg for current lets consider november 2018 (today's date as 13) is selected
then the current data should be selected till novemeber 12 and MTD last year also should be selected till november 12 2017 for comparison
(NO filter only using the parameter )
I tried multiple if but nothing seems working for comparing the if class with the today month and year with the parameter selected.
[This data i tweaked to use the year 2015 as 2018 for getting the required fields]
I think you just need one parameter, e.g. use Enter Year
Below is the sample for your reference.
Hope this helps
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...