DATEDIFF function
For a moment, let's assume that the Tripduration
was not provided and we need to calculate it. Using the starting and ending time, we can create a calculated field that holds the duration. In fact, let's create the duration in the measurement of minutes rather than seconds or hours! Use the built-in function DATEDIFF()
to allow Tableau to compare the two dates stamps.
If you lost progress, load the workbook 1_3_datediff.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
