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.





9 views0 comments