Configuring the default display format for an attribute

By default, the display format for attribute values is based on the attribute's data type plus the user's current locale. You can change the default display format used for each attribute. Within specific components, you can then make some updates to the display format.

Note that you only configure the display format for the default locale version of the attribute. You do not configure formatting for the locale-specific attributes. Because the formatting configuration already takes the current locale into account, you do not need to configure the formatting for the locale-specific attributes separately.

From the attributes list on the Views page, to change the default display format for an attribute:

  1. Click the edit icon in the Standard Format column.

    The Format Option dialog displays.

    At the top of the dialog is a sample value that displays the current formatting selection based on your current locale.

  2. For numeric attributes:
    Basic number formatting fields for a view attribute
    1. Under Metric Type, click the radio button to indicate the type of number.

      A numeric attribute may be displayed as a regular number, a currency value, or a percentage.

      Note that if you set a numeric attribute to be a currency or percentage, that selection cannot be overridden at the component level.

    2. If the number is a currency value, then from the Currency list, select the type of currency. This selection determines the symbol to display next to each value.
    3. If the number is a percentage, then from the Percentage list, select whether to display the percentage (%) sign with the value.

      Note that if you use percentage as the format, Studio automatically multiplies the value by 100. So if the actual value is 0.05, Studio displays the value as 5%.

    4. Under Decimal Places, to display all numbers using the same default number of decimal places, leave Default selected.

      To display all of the decimal places from the original value, up to 6 places, click Up to 6 digits. Studio truncates any decimal places after 6, and removes any trailing zeroes.

      To specify the number of decimal places to use for all numbers, click Fixed length, then in the field, type the number of decimal places to display.

    5. From the Grouping Separator list, select whether to display the grouping separator (used to separate thousands).
    6. The Advanced Formatting section provides additional format options.
      Advanced Formatting fields for a numeric attribute value

      For each of the advanced items, you can choose to have the display determined automatically based on the user's locale, or select a specific option.

    7. From the Number Format list, select how to display positive and negative numbers.
    8. From the Decimal Separator list, select the character to use for the decimal point.
    9. From the Grouping Separator list, select the character to use for the grouping (thousands) separator.
  3. For a Boolean attribute, you can determine the values to display for each Boolean value.

    By default, 1 displays as the localized version of "True", and 0 displays as the localized version of "False". To set specific (but non-localized) values to display:


    Fields for configuring the display of Boolean values
    1. Click Custom Values.
    2. In the True field, type the value to display if the attribute value is 1 (True).
    3. In the False field, type the value to display if the attribute value is 0 (False).
  4. For a geocode, to set a specific number of decimal places to display for the latitude and longitude values:
    Value formatting fields for a geocode attribute
    1. Click Fixed length.
    2. In the field, type the number of decimal places.
  5. For a date/time attribute:
    Value formatting fields for a date-time attribute
    1. From the Date Display list, select the format to use for the date.

      The selected format is adjusted for locale. For example, for some locales the month displays first, and for others the day displays first.

    2. From the Time Display list, select the format to use for the time.
  6. For a time attribute, from the Time Display list, select the format to use for the time.
    Value formatting fields for a time attribute
  7. For all value types, the Multi-Value Formatting section indicates how to display multiple values.
    Multi-Value Formatting configuration for a view attribute

    The setting is applied whenever multiple values are displayed for an attribute, including when an attribute is by definition multi-value, and when the set aggregation is applied to an attribute.

    From the Multi-value Separator list, select the character to use to separate the values.

  8. To confirm the format configuration, click Apply.
  9. To save the changes to the view settings, click Save View.