I have created sample data based on your requirement like below with some weeks (week 22 - week 29)
Step 1: Create a Parameter named Include Current Week? and Provide the values string Yes or No
Step 2: Create a calculated field "Include Current Week Calc" to tag the parameter to date field
Step 3: Drag the Calculated field to Filter and Select True
Selected Parameter "No": Week 29 Excluded
Selected Parameter "Yes" : Week 29 Included
Hope it heps
Kindly mark this answer as helpful or correct to close the thread so that it will be helpful for others
This can be achieved quickly by Set although you have 3 options here ( In,Out and All) which I don't mind (but it depends )
This is my data-source
You can make use of Set
DATEPART('week', [Order Date])=DATEPART('week' ,TODAY())
DATEPART('year', [Order Date])=DATEPART('year' ,TODAY())
Just right click now and show filter
Click In for only current week and All for all the weeks Out for excluding current week
This really looks like what I need, but at the moment I don't have access to Tableau Desktop, so no, Params or Sets. I'm using Tableau Server (I know...), I'm working on getting it! Is there a way that this can be achieved without parameters?
A coworker has access to Desktop so I can ask him to do it for me !
Thank you so much for being so thorough, this helps a lot!
Sets look like an interesting approach! At the moment, I don't have access to all the features of Tableau Desktop as I'm using Server, I'm requesting a Desktop license . Today I will look for a coworker who has Desktop and will ask him to see how it looks!
I appreciate you for taking the time to help me out!