Cloudera Docs

Using custom display configurations

Data Visualization has a free-format option that enables you to specify numerical data formats. This Custom Format option provides a wide range of custom display configurations.

The following steps outline how to use the Display Format: Custom Format interface.

  1. Click the field you want to modify to open the FIELD PROPERTIES menu.
  2. Under FIELD PROPERTIES, click Display Format.
  3. In the Display Format modal window, select Custom Format from the Category menu.
  4. In the Customize Format text box, enter a valid format mask based on the examples provided in the modal window.
    For a full list of options, see Display Format Reference.
  5. Click SAVE.

Common number formatting

Some examples of common display formats follow:

  • Entering 1s produces decimal format with Roman numerals for unit abbreviation.

    For example, 37,253,956 renders as 37.253956M.

  • Entering ,.1f produces a format with 1 digit after the decimal, and comma for the thousands separator.

    So, 37,253,956 renders as 37,253,956.0.

  • Entering ,.2f produces a format with 2 digits after the decimal, and comma for the thousands separator.

    So, 37,253,956 renders as 37,253,956.0.

To configure unit abbreviation for large numbers, see Using custom display formats for large numbers.