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
- Click the header of the column you want to format and in the dialog box select Options.
- 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.
- 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.
