Concepts → Dynamic Field
About a dynamic field
Starting the 2023.7.0 release, Incorta introduced the dynamic field option.
A dynamic field is a group of dynamically interchangeable fields filtering option that affects all applicable insights on all tabs of the given dashboard.
A dynamic field enables the dashboard consumer to change the view between data that you need to display on a certain dashboard without having to create multiple dashboards.
A dashboard developer creates one or more dynamic fields.
A dashboard developer with Edit access rights to a dashboard can create and edit one or more dynamic fields. Here is how:
- In the Action bar of a dashboard, select More Options (⋮ vertical ellipsis icon).
- In the More Options menu, select Dashboard Filters Manager.
- In Dashboard Filters Manager, in the Data panel, select + Add in the Dynamic Fields tray.
- Configure the properties of the dynamic field by adding pills.
To apply the dynamic field to insight within a dashboard, you must edit the insight and add the configured dynamic field to its measure tray.
Properties for a dynamic field pill
The following are the properties of a dynamic field
Property | Control | Description |
---|---|---|
Fields | tray and pill | Drag and drop zero or more columns from the Data panel to the tray. |
Column Label | text box | Required. Enter the display name for the dynamic field. This name will appear as the name as a filterable column in the Filter dialog and as the filter bar pill name. |
Variable name | text box | Required. Enter the variable name. |
Default Field | drop down | Required. Select a default field for the dynamic field. A default value can be system variable, internal session variable, or external session variables. |
Hide from filter bar | toggle | Optional. Disabled by default. Enable to hide the dynamic field from the filter bar. |
Variables in dynamic field
As a dashboard developer, you can use variables in dynamic fields. You can only define these variables in a formula so you can use it. It is important to understand that a dynamic field must have a default value. So to define a variable, you must add it to a formula using the Add formula option.
Supported variables are:
- Date system variable
- External session variable
- Global variable
- Filter expression session variable
- Internal session variable
- Miscellaneous system variable
- Presentation variable
- You can add the dynamic field only to the measure tray.
- You cannot reference a dynamic field in a formula