Formatting values displayed on a component

On a component edit view, when the component displays attribute or metric values, you can use the Format drop-down list to select the format to use.

The default format for an attribute value is based on the attribute data type. For metrics, which are calculated from attributes, the format must be some form of a number. You should make sure to select a format that makes sense for the displayed values.

When you select a format, Studio displays the appropriate configuration options for that format.

The available formats and their associated configuration options are:

Integer Indicates that the value is an integer.
For an integer value, you can configure:
  • The character to use to separate the thousands
  • Whether to display a % sign after the value
Currency Indicates that the value is a currency value.
For a currency value, you can configure:
  • The character to use to separate the thousands
  • The character to use for the decimal
  • The number of decimal places to include
  • The currency symbol to use
  • Whether to display the currency symbol in front of the value (prefix) or after the value (suffix)
Decimal Indicates that the value is a decimal number.
For a decimal value, you can configure:
  • The character to use to separate the thousands
  • Whether to display a % sign after the value
  • The character to use for the decimal
  • The number of decimal places to display
String Indicates that the value is a text string.
For a string value, you can configure the capitalization. You can either:
  • Keep the string as it is
  • Convert the string to all upper case
  • Convert the string to all lower case
  • Convert the string to title case (first letter of each word is capitalized)

You also can provide a number of characters after which to truncate the value. For example, for a long description, you may want to only display the first 200 characters.

Date Indicates that the value is a date.

Note that a value can only use the date format if it is stored as an Oracle Endeca Server date value (milliseconds since epoch). This option cannot be used for dates stored using other formats.

For a date value, you can configure the format to use. The options are:
  • American style (MM/DD/YYYY). For example, for October 20, 2010, the American style date would be 10/20/2010.
  • European style (DD/MM/YYYY). For example, for October 20, 2010, the European style date would be 20/10/2010.