IniziaInizia gratis

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.

Questo esercizio fa parte del corso

Analyzing Data in Tableau

Visualizza il corso

Esercizio pratico interattivo

Passa dalla teoria alla pratica con uno dei nostri esercizi interattivi

Inizia esercizio