Number

Format

These are the number formatting options that can be selected. The full list is: no format, number, abbreviated number, dollar, percentage, and time (days, hours, etc).

Decimal Places

This specifies the number of decimal places on the value.

Significant Digits

This specifies the number of significant digits that should be used, in the case that the format is Abbr.

Time Format

Specifies the time format for numeric values. Options:

  • Standard: Formats as DD days HH:mm:ss (see date format options)
  • Abbreviated: Shows largest nonzero value of days, hours, minutes, or seconds.
  • Custom Time Format: Formats using your custom format (see date format options).
  • Custom Total Duration: Treats input as a Duration and uses your custom format (see duration format options). To add additional text, wrap it in single quotes, e.g., dd 'days' hh 'hours'.

Include thousands-separators

This specifies if separators (depending on internationalization) should be used for values over 999.

Multiplier

This specifies a numerical multiplier for the value.

Unit

This specifies a unit for the value, e.g. hours, orders, etc.

String

The following are the formatting options available for strings in tables.

Normal

This is the default string format. No modifications are made, the string will appear exactly as it is in the dataset.

Category

Each unique string will be tagged with a different color, the default color palette will appear below the format section, and the color for each category can be updated.

Cells formatted as links will allow users to navigate to other pages from a row in a table. Choosing Label allow you to specify custom text that will appear in each row for that column as the display for the underlying link. Column will allow to pick another column within the dataset as the display for the underlying link.

Image

Cells that have image urls can be formatted to display the image in the table with this format option. You can also select the shape of the image, either circle or square.

Date

Dates within tables are also fully customizable. Choose either a preset date format option, or choose Custom and input a date format. Read more about date format options here