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.

1. 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".

1. Verify Property Creation

• Check the property listed in the Dynamic Property panel.

• Copy the property name format: [[PropertyName]] and close the panel.

1. Save metric to Dashboard

• Click the "Save to Dashboard" button.

• Then, use [[PropertyName]] format in

  • Metric Title

  • Metric Description

  • Metric Long Description, and

  • Footnote

1. View Dynamic Property

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