# Dataset Properties

The Dataset tab is the window that can be used to configure the dataset fields of a component. Each field has several properties that can be set using the Properties tab that appears at the end of this window.

* Map a data connection using the drop-down menu. (Ref. [***Connecting to a Data Source***](https://docs.bdb.ai/7.6/data-visualization/governed-dashboards/connecting-to-a-data-source) section).
* Drag and drop the required fields as described below:
  * **Category**: It takes the fields selected as dimensions for the component.
  * **Series**: It takes the fields selected as measures for the component.
* Configure the ***Properties*** displayed at the bottom of the window.
* The ***Properties*** tab will display the following information for the selected data field:

## Category Properties <a href="#category-properties" id="category-properties"></a>

The following properties information will appear for the Category data field.

* **Field Name**: It will display the default name of the field.
* **Display Name**: Provide a display name for the data field.
* **Visible**: Enable or disable the visibility of the field.
* **Color**: Set color for the selected data field.
* **Data Store Date**: Select any one date format for the Data Store to display the Date values.

​![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2Fb0PE2vYBXYWFH5wnrfJ1%2Fimage.png?alt=media\&token=390f34c2-fb78-4388-bd7c-2ce098b788d9)​

## Series Properties <a href="#series-properties" id="series-properties"></a>

The following properties information will appear for the Series data fields.

* **Field Name**: It is the default name for the selected data field.
* **Display Name**: Provide a display name to the selected data field.
* **Visible**: enable or disable this option to allow the visibility of the selected data field.
* **Color**: Set color of the selected data field.
* **Opacity**: Set the opacity for the selected data field.
* **Data Label**: This option redirects to set the [Data Label Properties](https://docs.bdb.ai/7.6/data-visualization/governed-dashboards/configuration/data-label) for the selected data field.
* **Data Store Type**: Select any one option out of the given arithmetic operations as Data Store Type.

![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FFsEBDb0DjKufNG4TIn7X%2Fimage.png?alt=media\&token=18942135-6eaa-493d-954c-60b144bbe1fd)​

## Dataset Properties tab for the ***Data Grid*** component <a href="#dataset-properties-tab-for-the-data-grid-component" id="dataset-properties-tab-for-the-data-grid-component"></a>

The Data Grid components contain some more properties under the ***Properties*** tab of the Dataset.

The following fields are available under the ***Properties*** tab.

* **Field Name**: It is the default name for the selected data field.
* **Display Name**: Provide a display name to the selected data field.
* **Visible**: Enable or disable this option to allow or restrict visibility of the selected data field.
* **Frozen Column:** Enable or disable Frozen column option for the selected data field.
* **Width:** Set the desired width for the selected data field by using the stepper option.
* **Color:** Select a color using this option for the selected data field.
* **Text Align**: Select an alignment option for the Column text display. The supported options are Left, Center, and Right.
* **Unit**: Select a currency unit option using the drop-down option. The supported unit options are None, Auto, %, K, M, B, T, Q, Lacs, and Cr.
* **Precision**: Select a precision option to be shown on the selected data field (up to 8 precision places are supported).
* **Currency**: Select a currency None, CENT, EURO, INR, POUND, USD, and YEN.
* **Position**: Select a position option from the drop-down option. The supported options are ***Prefix*** and ***Suffix***.
* **Row Aggregation**: Select an aggregation option using the drop-down option. The supported options are None, Sum, Average, Count, Minimum, and Maximum.
* **Show Tooltip**: Enable or disable the tooltip by using the given checkbox option.
* **Tooltip Field**: This option allows the user to provide tooltip for the selected column.

​![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FU5ZGERjdNDudWL4W9vC2%2Fimage.png?alt=media\&token=b14ba140-abab-47dd-9b4f-19a2a57854e9)​

* **Column Type**: Select a column type option using the drop-down option. The supported Column types are None, Numeric, Hyperlink, Image, Bullet, Progress Bar, Sparkline, Pie.
* **Number Formatter**: Select a number formatter option using the drop-down option. The supported choices are None, Indian, and international.
* **Sorting**: Enable or disable sorting option by using the given checkbox.
* **Data Store Type**: Select a Data Store Type option from the supported options.
* **Data Store Date**: Select a date format to reflect the date columns in the dashboard.
* **Column Style**: Enable or disable the column style option by using the checkbox.
* **Font Color**: Select the font color.
* **Font Size**: Set a font size using the given stepper button to increase or decrease the font size.
* **Font Style**: Select a Font Style using the drop-down menu. The supported options are ***Normal*** and ***Italic***.
* **Font Weight**: Select a font weight option using the drop-down option. the supported choices are Normal, Bold, 300, 600, and 900.
* **Font Family**: Select a font type using the drop-down option. The supported fonts are Arial, BizVizFont, BizvizFontRegular, Cambria, Helvetica, Lucida Bright, Monotype Corsiva, Papyrus, Raleway, Roboto, Times New Roman, Ubuntu, Verdana.

​![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2F1aescswhElHbHlXlnP6C%2Fimage.png?alt=media\&token=35e90f71-e010-44ca-8b48-061d0f46dd06)​

{% hint style="info" %}
*Please Note: The supported Data Store options are Sum/Mean/Count/Min/Max/Variance/Standard Deviation.*

​![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2F84aRycQ89UvN6XYpGfUB%2Fimage.png?alt=media\&token=e3796f96-99aa-40ea-9a6c-bd8c2385ad77)​
{% endhint %}
