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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
