In Workforce Analytics, the Group Interval options for a Date/Time field does not include the ability to only show the time without the date. But for fields like Roster Start Time, Roster End Time, Actual Start Time, or Actual End Time, you may not wish to display both a date and time.
We can convert the column to only show a time using a Calculated Field in Workforce Analytics.
When in the binding (gear) for a Data Insight report, click the f+ icon to create a new calculated field.
Update the Name of the calculated field to something more descriptive and change the Field Type to String.
You'll then want to add the following formula:
Substring(ToStr([Actual_Start_time]),
5+CharIndex(GetYear([Actual_Start_Time]),ToStr([Actual_Start_Time])))
Note: This is for Actual Start Time. If you are converting a different field, such
as Roster End Time, make sure you update all three field names in the formula.
They are blue in the calculated field box to help you. The correct field name can
be found in the Fields list below the formula.
Save the calculated field and make sure it is one of the columns in your report. Here's what it looks like with the original column versus the calculated field column side-by-side.
