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.

17 views0 comments