Get startedGet started for free

Partitioning with datepart

Date format manipulation is an unavoidable part of dealing with time series data in Tableau. Sometimes we're going to need to segment our time series data into different granularities outside of month, day and year.

In this exercise, we'll revisit the Citibike dataset where we'll utilize the DATEPART() function in combination with the IF statement for additional segmentation of our data!

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

This exercise is part of the course

Time Series Analysis in Tableau

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise