How to Calculate Weekends in Tableau

Do you need to create a calculation in Tableau which differentiates between weekends and weekdays?

If that’s the case, look no further! The video below demonstrates how you can use the DATEPART() function to create a weekend calculation. For the code behind the calculation, skip down past the video.

Weekend Calculation Code:
IF DATEPART('weekday',[Date]) = 1 OR DATEPART('weekday',[Date]) = 7
THEN "Weekend"
ELSE "Weekday"
END

Want to keep up with the latest Tableau trends? Subscribe to this channel and join us for one of our upcoming events!

https://www.eventbrite.com/o/onenumber-15678294163

Видео How to Calculate Weekends in Tableau канала OneNumber - Tableau Experts