A couple of people have asked me how to filter out weekend data in a Tableau Workbook.
You can do this by creating a Calculated Field and place this in the Filters pane of your Tableau Dashboard.
Here is an example using the Superstore Data set.
Weekend Calculated Field
DATENAME('weekday',[Order Date])="Saturday"
OR DATENAME('weekday',[Order Date])="Sunday"
The above formula will pull only data with the above weekday names.
This field will create a True/False formula. When you place it on your Filters card, select False to only display data that falls during the week and not the weekend.
![](https://static.wixstatic.com/media/fb3a64_f4ddef62d4c94b12bc56fb8ad0f7e8cc~mv2.jpg/v1/fill/w_452,h_564,al_c,q_80,enc_avif,quality_auto/fb3a64_f4ddef62d4c94b12bc56fb8ad0f7e8cc~mv2.jpg)
Comments