KNOWLEDGE BASE

Isolate Time from Date and Time Field


Published: 11 Mar 2019
Last Modified Date: 20 Jul 2023

Question

How to create views which show time without date. For example, creating a schedule of classes, graphing the number of calls per hour over multiple days, or showing when employees clock in and out.

Environment

Tableau Desktop

Answer

CLICK TO EXPAND SOLUTION
Option 1: Use a Date & Time field and then format the values as time only
CLICK TO EXPAND SOLUTION
Option 2: Use the Hour date part
CLICK TO EXPAND SOLUTION
Option 3: Shift all date & time values to the same date
CLICK TO EXPAND SOLUTION
Option 4: Append all times to the same date to create a date field

Additional Information

Tableau requires times in Date & Time fields to be associated with a date. This allows for chronological sorting across days.

In order to graph times from different days on top of each other, the times must be shifted to the same day. If the original data does not include a date, then a Date & Time field can be created with an arbitrary date.

Did this article resolve the issue?