> For the complete documentation index, see [llms.txt](https://endash-guidance-docs.gitbook.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://endash-guidance-docs.gitbook.io/docs/dashboard/custom-column-configuration.md).

# Custom column configuration

## Overview

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FKS41cmY5RjfORu9vHF7P%2Fimage.png?alt=media&amp;token=635d2fb8-4100-41e5-b1a8-f51a74973c97" alt=""><figcaption></figcaption></figure>

* You can customize a column of a widget by hovering on any column and clicking on the 🖊 icon. This guide will use the Table widget as an example.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FrCzNudXjjVx0Eo5FlN81%2Fimage.png?alt=media&amp;token=570df6c9-0564-4d28-9f69-1bce4de7d8e9" alt="" width="433"><figcaption></figcaption></figure>

* The Edit column popup will display. Each column type shall have different options.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2F8UITyqx8CygHt4uh3DLI%2Fimage.png?alt=media&amp;token=330c7d67-1354-4446-8b62-7a56af43fb3d" alt="" width="428"><figcaption></figcaption></figure>

* Click on the Format button to see further format options.

{% hint style="info" %}
The default option is:

* No Prefix and Suffix
* 1,234.5 formation
* Decimal point: 0
* Comma, period&#x20;
* Show thousands separator
  {% endhint %}

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FmLQivdTwry4BiOuMxmIb%2Fimage.png?alt=media&amp;token=3c7d2478-7f9e-4cb2-ae60-9ca24a1d5d7a" alt="" width="352"><figcaption></figcaption></figure>

* For Text type, it only has Column name & type, Prefix, and Suffix fields.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FEq2AHQEi3Y5dnWbtHw3O%2Fimage.png?alt=media&amp;token=f171d7fb-c330-497b-8849-c7b3e7bf5e37" alt="" width="460"><figcaption></figcaption></figure>

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FEXe3YoNswP06mKNPg7gg%2Fimage.png?alt=media&amp;token=c5fc5393-868e-4000-931a-f43527ad747d" alt="" width="462"><figcaption></figcaption></figure>

* For Date and Boolean types, they only have Column name & type field.

## Column name

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FJUWLxCvsySYPOJouWZ8K%2Fimage.png?alt=media&amp;token=111bd159-fa6b-41d4-9f5e-6353dfd1303d" alt="" width="499"><figcaption></figcaption></figure>

* Simply change the name of the column by typing in the Column name & type field.

## Prefix and Suffix

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2Fp0PqOI9hs7KbbBL87xC1%2Fimage.png?alt=media&amp;token=f1b9d99c-43f0-4b17-8b12-f2cb56361ff0" alt="" width="506"><figcaption></figcaption></figure>

* Continue to add Prefix or Suffix to the column.

{% hint style="info" %}
Maximum character is 10.
{% endhint %}

## Format

### Preset

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FAwp87JRyCe7snB7Mvufz%2Fimage.png?alt=media&amp;token=cc94ffe6-6b0f-43ea-963d-ad63c87512cf" alt="" width="506"><figcaption></figcaption></figure>

* Choose the Preset you want to display for the column.

### Decimal places

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FrXGEa4zEiW8WXrJ3IheK%2Fimage.png?alt=media&amp;token=7e78bb33-8a43-430c-82e4-9dc461485207" alt="" width="491"><figcaption></figcaption></figure>

* Click on the Decimal places and choose your desired option.

### &#x20;Separators and abbreviation

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FWCxQSiCaMTgTxIRfNa5L%2Fimage.png?alt=media&amp;token=12ca09d8-26fd-4f77-b064-79528fade9bc" alt="" width="502"><figcaption></figcaption></figure>

* For 1,234.5 formation, you can choose the separator option.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2F0AjZzuvQ3yjcgLnPSQYB%2Fimage.png?alt=media&amp;token=a1b78a8c-5522-4168-a050-7c4cd40806c1" alt="" width="500"><figcaption></figcaption></figure>

* You can do the same with the  12345 formation.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FBK7q0XwikpBcEzz0LXAi%2Fimage.png?alt=media&amp;token=35764dab-dcbf-400b-a663-133763bc4f3c" alt="" width="491"><figcaption></figcaption></figure>

* For 1.2M, you can choose the abbreviation option.

## Confirm your option

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FOGetMCIfM3A9iylYJcg4%2Fimage.png?alt=media&amp;token=1e81cf7f-7d09-41f6-9ff7-803b8b31580c" alt="" width="504"><figcaption></figcaption></figure>

* Click the Done to confirm your option.
* To close the popup, click on the Cancel button, the X button on the top right, or simply click outside it.
* You can click the Reset button to revert your selection back to the previous save changes of the popup.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FFj6N9vGXAxsR4PrI00h3%2Fimage.png?alt=media&amp;token=599b1636-dc2f-4cac-90ca-dd99128fa3d7" alt="" width="537"><figcaption></figcaption></figure>

{% hint style="info" %}
Your custom column setup will only apply to that column of the selected widget. It will not affect other widgets with the same data model.
{% endhint %}
