top of page

Weekend Filter

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.





18 views0 comments
bottom of page