(v23) Configure Date and Time Formatting for Visuals

Configure Date and Time Formatting for Visuals

This applies to: Visual Data Discovery

Date and time formats for Time attributes are set at the source. You can override source formats by changing a visual directly, without affecting the underlying source format. For information on other settings that may apply to Time attributes, see Configure Date and Time Formatting - Data Sources.

Note: You can also override formatting for the Number attribute at the visual level. See Configure Number Formatting for Visuals.

Configure Formatting for Visuals - Time Attributes

1. Select the visual with time attributes you want to format in a dashboard or the visual gallery.

2. Select a Metric, X or Y axis, Group, Color, Trend line, size, or other available measure. A dialog for your selection opens.

   

3. Locate your time field using Search, or navigate to the field or fields you want to format. Select the menu for a field, then select Format. The Format: <field> work area opens.

   

4. Define your format options, and select Apply to apply to this field.

5. Repeat for all fields you want to modify.

   Note: To clear your applied changes to a field, open the formatting work area and select Reset.

Format Options Time Attribute for Visuals

When you configure formatting at the visual level, you may not see all the options listed below, depending on the visual you're updating and the available time segments included in the source data.

Format Option	Description
Second	Select Numeric (0-59) or 2-Digit (00-59).
Minute	Select Numeric (0-59) or 2-Digit (00-59).
Hour	Select Numeric (1-24) or 2-Digit (01-24).
Hour12	Select a 12 or 24 hour format option for Hour12. Auto displays the hour format defined in the source data. True overrides the source format, displaying the hours in 12 hour format, with an appended AM or PM. False overrides the source format, displaying the hours in 24 hour format.
Day	Select Numeric (1-7) or 2-Digit (01-07).
Month	Select Numeric (1-12), 2-Digit (01-12), Long (January, March), Short (Jan, Mar), or Narrow (J, M).
Weekday	Select Long (Friday, Sunday), Short (Fri, Sun), Narrow (F, S), or None. The default is None, to show no day of the week.
Quarter	Select Range, Narrow, Numeric (1-4), or 2-Digit (01-04). Set Granularity to Quarter; you can define Quarter formatting after the visual reloads with Quarter granularity.
Year	Select Numeric (2022) or 2-Digit (22).