Localized Currency Symbols
This guide provides a practical approach for utilizing Dynamic Property to dynamically display revenue in multiple currencies for different countries.
Last updated
This guide provides a practical approach for utilizing Dynamic Property to dynamically display revenue in multiple currencies for different countries.
Last updated
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:
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.
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.
Check the property listed in the Dynamic Property panel.
Copy the property name format: [[Units]] and close the panel.
In the Formatting Section, set the prefix as [[Units]]
This ensures that revenue values in the Y-axis display the correct currency code dynamically.
Click the "Save to Dashboard" button.
Then, use [[Units]] in
Metric Title
Metric Description
Metric Long Description, and
Footnote
The [[Units]] dynamic property updates the currency unit based on the selected country in the metric filter.
The [[Units]] dynamic property updates the currency unit based on the selected country in the dashboard filter.
Please refer the below link on how to create Dynamic Property:
