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.
Deze oefening maakt deel uit van de cursus
Analyzing Data in Tableau
Praktische interactieve oefening
Zet theorie om in actie met een van onze interactieve oefeningen.
Begin met trainen