1. Home
  2. Latest Release Docs
  3. Guides
  4. Concepts
    1. Aggregate filter
    2. Alias
    3. Apache Avro™
    4. Apache Kafka™
    5. Applied filter
    6. Base table
    7. Bookmark
    8. Business schema
    9. Business schema view
    10. Business schema view column
    11. Business schema view formula column
    12. Column
    13. Connector
    14. Dashboard filter
    15. Dashboard folder
    16. Dashboard runtime filter
    17. Data agent
    18. Data alert
    19. Data destination
    20. Data purge
    21. Data retention
    22. Date system variable
    23. Distinct filter
    24. Dynamic field
    25. Expression
    26. External data source
    27. External session variable
    28. Filter expression
    29. Filter expression session variable
    30. Filter option
    31. Formula column
    32. Formula expression
    33. Full load
    34. Global variable
    35. Incorta Analyzer Table
    36. Incorta Analyzer Table column
    37. Incorta Analyzer Table formula column
    38. Incorta Analyzer View
    39. Incorta Analyzer View formula column
    40. Incorta Spark SQL View
    41. Incorta SQL Table
    42. Individual filter
    43. Insight filter
    44. Internal query expression
    45. Internal session variable
    46. Join
    47. Join condition
    48. Join condition column
    49. Join filter
    50. Join filter column
    51. Level-based measure
    52. Load filter
    53. Local data file
    54. Local data folder
    55. Materialized View
    56. Materialized View column
    57. Materialized View formula column
    58. Measure filter
    59. Miscellaneous system variable
    60. Multi-source table
    61. Physical schema
    62. Physical schema table
    63. Physical schema table column
    64. Physical schema table formula column
    65. Physical schema table runtime security filter
    66. PostgreSQL (Incorta SQL) View
    67. Presentation variable
    68. Prompt
    69. Query system variable
    70. Runtime business view
    71. Runtime business view formula column
    72. Runtime security filter
    73. Schema evolution
    74. Session variable
    75. Shared Storage
    76. Upgrade Readiness
    77. Variable
    78. Visualization
  5. Tools
  6. References
  7. Integrations
  8. Data applications
  9. Release Notes
  10. Incorta Premium

Concepts → Dynamic Field

About a dynamic field

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

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.

Starting 2024.7.x, you can add a label suffix to the dynamic field group during the insight design, allowing for the usage of dynamic field groups multiple times within an insight while differentiating their intent of use by providing a written value or providing a presentation variable as a suffix.

Properties for a dynamic field pill

The following are the properties of a dynamic field:

PropertyControlDescription
Fieldstray and pillDrag and drop zero or more columns from the Data panel to the tray.
Column Labeltext boxRequired. 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 nametext boxRequired. Enter the variable name.
Default Fielddrop downRequired. 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 bartoggleOptional. 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
Known Limitations
  • You can add the dynamic field only to the measure tray.
  • You cannot reference a dynamic field in a formula