Table Value Formatting
The values in a table on a dashboard can be formatted, and they each have a set of formatting options, dependent on the value type. This page details all the possible formatting options for each value type.
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.
Link
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