# Display

The Display section allows you to specify how the column header and their values should be displayed based on your needs.&#x20;

Go to **Setup > Columns.**&#x20;

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FTJIMed3MTATDcBVth612%2Fimage.png?alt=media&#x26;token=c41b8e41-124d-46e4-a0b7-5acacaaef4d1" alt=""><figcaption><p>Accessing the 'Columns' section</p></figcaption></figure>

Click on the pencil icon beside the column name or double-click on the column name. Go to the **Display** tab.

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FSk3w3rlbwyNUFF5V2LFG%2Fimage.png?alt=media&#x26;token=5f842d8d-4f10-4d53-a7ca-700eb3b66e6a" alt=""><figcaption><p>Display properties</p></figcaption></figure>

Here, you can add and configure various display properties, such as the date format, display name, thousand separator, prefix, and suffix.&#x20;

## 1. Format

Using the Format property, you can define how the date and date-time values should be presented in the columns. You can choose from various date and date-time formats such as 'MM/DD/YYYY', 'DD/MM/YYYY', 'DD MMM, YYYY hh:mm:ss', and so on.

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2F9tL3ZfnBIleuHt3LVqxB%2Fimage.png?alt=media&#x26;token=e94da4c6-f164-4852-bc02-ae6caeaa66d3" alt=""><figcaption><p>Date format</p></figcaption></figure>

## **2. Display Name**

The Display Name property enables you to display a user-friendly name for the column header, different from the actual field name in the database. For instance, the 'ProductSubcategoryKey' field in the database can be displayed as 'Product SubCategory' in the visual for enhanced clarity.

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2F8lowCUOnAGMZ1dPUcVfv%2Fimage.png?alt=media&#x26;token=81a68e9a-abf5-4683-a92f-381ac5a1e872" alt=""><figcaption><p>Display Name</p></figcaption></figure>

## **3. Description**

You can use the 'Description' field to include additional information in the column headers, helping users understand the data better. An 'i' icon is added beside the header name, and when you hover over it, the additional description is shown.

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FSbiBtqduZF5PugpyTBHK%2Fimage.png?alt=media&#x26;token=51a62517-3348-426d-b456-2c36dc4c6d95" alt=""><figcaption><p>Description</p></figcaption></figure>

## **4. Thousand Separator**&#x20;

By default, numbers in the column are displayed continuously without any thousand separators. To enhance the readability of large numeric values, you can add a comma, a period, or a space as a separator for every group of thousands.

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FSwZy1pt4f13w9vws9q64%2Fimage.png?alt=media&#x26;token=2c292024-26ef-46c3-969c-a089a37afdc1" alt=""><figcaption><p>Thousand separator</p></figcaption></figure>

## **5. Prefix**

This property allows you to add a prefix of up to two characters before numeric or decimal column values. This is commonly used to indicate currency symbols.

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FZnoL3xjRCLUfDkgkT4vp%2Fimage.png?alt=media&#x26;token=9ae081e8-b677-49cf-b6ab-10b2bac5e451" alt=""><figcaption><p>Prefix</p></figcaption></figure>

## **6. Suffix**

This property lets you add a suffix of up to two characters after numeric or decimal column values. This can be used to indicate measurement units like kilograms, centimeters, and percentages.

We have now discussed all the column properties that can be configured from the **Columns** section. In the next section, we will look at other options, such as importing/exporting configurations and adding columns.
