> ## 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.

# Localized Currency Symbols

> This guide provides a practical approach for utilizing Dynamic Property to dynamically display revenue in multiple currencies for different countries.

### Use Case: Representing Revenue in Different Countries

An e-commerce business operating in multiple countries needs to represent revenue in different currencies. The finance team chooses to analyze revenue trends in localized formats by selecting different countries. Here are the steps to implement Dynamic Property for revenue tracking:

### 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/rztAaW4K131jq2rk/images/developer-docs/image-lcs1.png?fit=max&auto=format&n=rztAaW4K131jq2rk&q=85&s=c8bad8d299e20d7bae792e1a2fa11988" width="1120" height="524" data-path="images/developer-docs/image-lcs1.png" />
</Frame>

### 2. Configure Dynamic Property:

* Enter the Property Name and choose between the two Property Types:
  * **"Auto"**
    * Choose the dataset and the column you want to consider.
  * **"Custom"**
    * Enter your SQL query to choose your dynamic value and dependent columns, and select the column name.
* In this example, we select the column containing **currency codes** or create a **custom query** and save it as `[[Units]]`.
* Then, select the dependencies: dashboard or metric filter type. (Optional)
* Click **"Create"** to save the property.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/rztAaW4K131jq2rk/images/developer-docs/image-lcs2.webp?fit=max&auto=format&n=rztAaW4K131jq2rk&q=85&s=aa6946014940b49faaa7b25b6895ef4e" width="688" height="322" data-path="images/developer-docs/image-lcs2.webp" />
</Frame>

### 3. Verify Property Creation

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

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/rztAaW4K131jq2rk/images/developer-docs/image-lcs3.png?fit=max&auto=format&n=rztAaW4K131jq2rk&q=85&s=eac6ede43dcd63ce2cfb89cbe5afee68" width="1120" height="521" data-path="images/developer-docs/image-lcs3.png" />
</Frame>

### 4. Configure formatting options:

* In the Formatting Section, set the prefix as \[\[Units]]
* This ensures that revenue values in the **Y-axis** display the correct currency code dynamically.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/rztAaW4K131jq2rk/images/developer-docs/image-lcs4.png?fit=max&auto=format&n=rztAaW4K131jq2rk&q=85&s=df10199d105e0c4892c7145321859678" width="1120" height="526" data-path="images/developer-docs/image-lcs4.png" />
</Frame>

### 5. Save metric to Dashboard

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

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/rztAaW4K131jq2rk/images/developer-docs/image-lcs5.webp?fit=max&auto=format&n=rztAaW4K131jq2rk&q=85&s=0be4a29d0252c27cb55efc5dad574ff1" width="688" height="322" data-path="images/developer-docs/image-lcs5.webp" />
</Frame>

### 6. Verify Dynamic Property Functionality

#### Metric Filter Example:

The `[[Units]]` dynamic property updates the **currency unit** based on the **selected country** in the **metric filter**.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/rztAaW4K131jq2rk/images/developer-docs/image-lcs6.webp?fit=max&auto=format&n=rztAaW4K131jq2rk&q=85&s=538779384b977d79e371ba666798f89d" width="688" height="323" data-path="images/developer-docs/image-lcs6.webp" />
</Frame>

### Dashboard Filter Example:

The `[[Units]]` dynamic property updates the **currency unit** based on the **selected country** in the **dashboard filter**.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/rztAaW4K131jq2rk/images/developer-docs/image-lcs7.webp?fit=max&auto=format&n=rztAaW4K131jq2rk&q=85&s=c83ade91a16eb8a36df0db2d8c34a174" width="688" height="323" data-path="images/developer-docs/image-lcs7.webp" />
</Frame>

Please refer the below link on how to create Dynamic Property:

<Card title="Dynamic Property" href="https://docs.usedatabrain.com/guides/metric/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.
</Card>
