> ## Documentation Index
> Fetch the complete documentation index at: https://docs.explo.co/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](https://moment.github.io/luxon/#/formatting?id=table-of-tokens))
* **Abbreviated**: Shows largest nonzero value of days, hours, minutes, or seconds.
* **Custom Time Format**: Formats using your custom format (see [date format options](https://moment.github.io/luxon/#/formatting?id=table-of-tokens)).
* **Custom Total Duration**: Treats input as a Duration and uses your custom format (see [duration format options](https://moment.github.io/luxon/api-docs/index.html#durationtoformat)). 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](https://moment.github.io/luxon/#/formatting?id=table-of-tokens)

<Note>
  The beginning of the week starts on Monday.
</Note>
