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.
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.
Configure Dynamic Property:
Enter the Property Name and choose between the two Property Types: "Auto" or "Custom"
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".
For Custom Property Type:
Enter your SQL query to choose your dynamic value and dependant columns, and select the column name.
Then, select the dependencies: dashboard or metric filter type. (Optional)
Finally, click on "Create".
Verify Property Creation
Check the property listed in the Dynamic Property panel.
Copy the property name format: [[PropertyName]] and close the panel.
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:
Localized Currency SymbolsThis guide provides a practical approach for utilizing Dynamic Property to dynamically display revenue in multiple currencies for different countries.Save metric to Dashboard
Click the "Save to Dashboard" button.
Then, use [[PropertyName]] format in
Metric Title
Metric Description
Metric Long Description, and
Footnote
View Dynamic Property
The dynamic property [[Unit]] shows different currency units based on the selected country.
Last updated