Data formatting options

Numeric, text, date, and datetime fields support a number of different formatting options that are useful in different situations.

Numeric data formats

Supported formats

Numeric fields support the following formatting options:

  • number
  • currency
  • financial
  • percent

Rounding options

Any format can be displayed as the exact number, rounded to the nearest whole number, or rounded to two decimal places.

Note

Rounding is to the nearest decimal.

Note

The rounding settings you choose here are used in visualizations based on this data.

Text data formats

Text data fields support plain text or a subset of HTML elements.

Supported HTML elements

  • bold <b>
  • italic <i>
  • underline <u>
  • ordered list <ol>
  • unordered list <ul>
  • anchor <a>
  • image <img>

Image tag src attributes may reference images hosted on external domains.

Note

If you click an HTML link in the table, the page opens within the Table View. Use the browser back button to navigate back to the table.

When to use HTML formatting

HTML formatting is useful for:

  • free form text questionnaire responses that include HTML formatting
  • .csv files that include HTML formatting in specific fields
  • records imported from Analytics, Analytics Exchange, or Add-In for Excel that include HTML formatting

Date and datetime data formats

Date and datetime fields support a number of common date formats that are used in different locales and by different systems.

Format column data

  1. Click the header of the column you want to format and in the dialog box select Options.
  2. From the list of display format options, select the format you want to apply to the data in the column.

    Result The window closes and the formatting is applied to the table.

  3. To save the interpretation, on the right-hand side of the page, do one of the following:
    • Click Save.
    • Click More Actions and select Save As.

    When you save, you can edit the title and optionally enter a summary for the visualization.