Get startedGet started for free

Weekday or weekend?

When analyzing consumer activity, it's common to compare weekends and weekdays. However, our data doesn't provide a field to directly classify the data this way. We can easily use the Start Time, which is a time stamp generated by the docks, and the Tableau DATEPART() function to identify if the day contained in the Start Time is a Sunday or Saturday. When DATEPART() is asked to consider the 'day' part of the time stamp, it will return a numeric value. Using IF/THEN/ELSE logic structure, we'll be looking for 1 for Sunday or 7 for Saturday.

If you lost progress, load the workbook 1_4_week.twbx from the Workbooks folder on the Desktop.

This exercise is part of the course

Analyzing Data in Tableau

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise