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

# Dynamic Property

> This guide explains the process of using dynamic properties in metric creation. These properties can fetch dynamic values directly from the database, with dependencies on dashboard or metric filters.

### 1. Access Dynamic Property:

* In the metric creation page, click on **"\[X]"** icon near the sort icon.
* This will open the **"Dynamic Property"** panel on the right side of the screen.
* Then, click on **"+Property"** to add a dynamic property to your metric.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/3OVuv1yincv0D6pa/images/guides/access-dp.gif?s=873acae30b582c5aac298ff78f06f2b3" alt="Opening the Dynamic Property panel from the metric creation page" width="1630" height="919" data-path="images/guides/access-dp.gif" />
</Frame>

### 2. Configure Dynamic Property

Enter the Property Name and choose between the two Property Types: **"Auto"** or **"Custom"**

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/3OVuv1yincv0D6pa/images/guides/auto-custom.png?fit=max&auto=format&n=3OVuv1yincv0D6pa&q=85&s=7a91076874b0e76ac5fa72908724677a" alt="Selecting between Auto and Custom dynamic property types" width="2940" height="1654" data-path="images/guides/auto-custom.png" />
</Frame>

#### For Auto Property Type

* Choose the dataset and the column you want to consider.
* Then, select the dependencies: dashboard or metric filter type. *(Optional)*
* Finally, click on **"Create"**.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/3OVuv1yincv0D6pa/images/guides/auto.png?fit=max&auto=format&n=3OVuv1yincv0D6pa&q=85&s=d3b388e6951b6d4fd6c2cb21754746e7" alt="Configuring an Auto dynamic property with dataset and column selection" width="2940" height="1652" data-path="images/guides/auto.png" />
</Frame>

#### For Custom Property Type

* Enter your SQL query to choose your dynamic value and dependent columns, and select the column name.
* Then, select the dependencies: dashboard or metric filter type. *(Optional)*
* Finally, click on **"Create"**.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/3OVuv1yincv0D6pa/images/guides/custom.png?fit=max&auto=format&n=3OVuv1yincv0D6pa&q=85&s=b44c53ddf5dd4b0fc5be8d91f69c9078" alt="Configuring a Custom dynamic property using SQL query" width="2940" height="1654" data-path="images/guides/custom.png" />
</Frame>

#### 3. Verify Property Creation

* Check the property listed in the **Dynamic Property** panel.
* Copy the property name format: `[[PropertyName]]` and close the panel.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/hRxI-z391a3Ay8M5/images/guides/verify-custom-property.png?fit=max&auto=format&n=hRxI-z391a3Ay8M5&q=85&s=d8978ddc6ddd5fa44c8451d4eb983e0e" alt="Verifying the created dynamic property listed in the panel" width="2940" height="1658" data-path="images/guides/verify-custom-property.png" />
</Frame>

#### 4. Use Dynamic Property in Metrics

In the **Formatting Options** of a metric, use the `[[PropertyName]]` format in:

* **Prefix**
* **Suffix**

This will dynamically update values based on selected inputs.

For more details, kindly refer the below link:

<Card title="Localized Currency Symbols" href="https://docs.usedatabrain.com/developer-docs/solutions-alchemy/localized-currency-symbols">
  This guide provides a practical approach for utilizing Dynamic Property to dynamically display revenue in multiple currencies for different countries.
</Card>

#### 5. Save Metric to Dashboard

* Click the **"Save to Dashboard"** button.
* Then, use the `[[PropertyName]]` format in:
  * **Metric Title**
  * **Metric Description**
  * **Metric Long Description**, and
  * **Footnote**

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/oJW5seGO2mMUK4Ch/images/guides/save.gif?s=c133b396162f09b2e8937e40fc2a9320" alt="Saving the metric with Dynamic Property fields applied" width="1629" height="920" data-path="images/guides/save.gif" />
</Frame>

#### 6. View Dynamic Property

The dynamic property `[[Unit]]` shows different currency units based on the selected country.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/hRxI-z391a3Ay8M5/images/guides/view-dynamic-property.png?fit=max&auto=format&n=hRxI-z391a3Ay8M5&q=85&s=0e2f720bcbd6d1c12f89ee1c7e8e5f73" alt="Viewing the dynamic property applied inside the metric visualization" width="2940" height="1654" data-path="images/guides/view-dynamic-property.png" />
</Frame>

<Check>
  You’ve successfully configured and applied Dynamic Properties in your metric!\
  Your metrics now respond intelligently to filters and user selections, enabling dynamic, context-aware values across your dashboards.
</Check>
