Add a variable to a dashboard

Latest Dynatrace

Use variables to filter your dashboards, to act as variable values in code tiles, and as placeholders in tile titles and Markdown tile text.

Add a variable

To add a variable to a dashboard

  1. In the upper-right corner of the dashboard, select > Variables.

    Add tile button

    The Variable panel is displayed.

  2. Define the variable.

    • Name: the name of the variable.
      • Only alpha-numerical values are allowed
      • A variable name must not start with dt_
    • Type: can be one of the following:
      • Query: the value is returned from a query you enter when you define the variable.
        • Select Run query to test your query.
      • Code: the value is returned from code you enter when you define the variable.
      • CSV: a comma-separated values (CSV) list of values.
        • To define possible values, enter them (separated by commas) in the box under Type.
        • To define a default value, select one from the Default value list.
        • To allow multiple values to be selected at the same time, turn on Multi-select.
      • Text: free text. You can enter a Default value. Your changes are saved automatically.

  3. Set Display settings.

    • Turn on the Display as filter on dashboard toggle if the variable dropdown should be displayed on the dashboard. Turn it off when you want it hidden, such as when the variable is used as a static value across tiles but should not be displayed to the dashboard user.
    • Turn on the Multi-select toggle if users should be able to select multiple values at the same time within the variable dropdown. Turn it off when you want to use only single values of the variable dropdown.
    • Select a Default value for the variable dropdown. If you do not enter anything in this field, the first available value will be selected.

  4. When you're finished, select < Variable at the top to go to the Variables panel, or close the panel to display the dashboard.

Variables in dashboards can be defined to depend on other variables.

  • The value of a variable is recalculated if its definition refers to another variable and the other variable's value changes.

    For example, if the value of variable A changes, the value of any variable whose definition refers to variable A is recalculated.

  • Loops are not allowed.

    For example, if the value of variable A depends on the value of variable B, the value of variable B can't depend on the value of variable A.

How you edit a variable depends on the Type. For details and examples, see Query variable, CSV variable, Code variable, or Text variable below.

Use a variable

After you create a variable, you're ready to use it in a query.

Always remember to prepend a variable name with $ in your queries.

For example, if you create a variable named MyTotal, you need to refer to it as $MyTotal in your query.

For example:

  1. Open the Add menu and select Variables to add a variable to your dashboard.

  2. Define the following variable:

    • Name: Host
    • Type: Query
    • Query:
    fetch dt.entity.host
    | fields entity.name

  3. Turn on Multi-select so you can select more than one value at a time to show in your visualizations.

    Your changes are saved automatically.

  4. Close the Variable panel.

Use with a Query Grail tile

  1. Open the and select Query Grail.

  2. Copy and paste the following query into the Query box and select Run.

    Notice that the query refers to our new variable as $Host, with the dollar sign indicating that it's a variable name.

    fetch logs, scanLimitGBytes: 20
    | filter in(host.name, array($Host))
    | makeTimeseries count(), by:{ host.name }

    or when not using a multi-select variable you can reference it like

    fetch logs, scanLimitGBytes: 20
    | filter host.name == $Host
    | makeTimeseries count(), by:{ host.name }

  3. Because you added a multi-select variable, you can use the value selector to determine which values are displayed in your visualizations.

  4. You can of course use your variable in multiple queries.

Use with an Explore tile

To use a variable in an Explore data tile

  1. Open the Add menu and select Logs.

  2. Select and then select host.name from the Available filters.

  3. In the added filter field, type $ to get suggestions for all available variables and then select $Host.

Note: Adding variables in Explore tiles only works for single-select variables in combination with the = operator.

List variables

After you add at least one variable to a dashboard, a icon displayed next to the existing variables in the upper-left corner of the dashboard.

  • Select the icon next to the variables on the upper-left corner of the dashboard. In the overlay select All variables.
  • Select the icon next to the variables on the upper-left corner of the dashboard. In the overlay select Summarize All variables.
  • Alternatively, first select the settings icon on the upper-right corner of the dashboard to open the detail view. In the detail view select Variables to list all existing variables.
  • If there is no icon next to the existig variables in the upper-left corner of the dashboard, there are no variables defined for the dashboard.

Edit a variable

  1. Select the icon next to the variables on the upper-left corner of the dashboard. In the overlay select All variables.
  2. In the Name column, select the name of the variable that you want to edit.
  3. Edit and verify the variable.
  4. Dismiss the Variables panel.

How you edit a variable depends on the Type. For details and examples, see Query variable, CSV variable, Code variable, or Text variable below.

Delete a variable

To delete a variable from a dashboard

  1. Select icon next to the variables in the upper-left corner of the dashboard. In the overlay select All variables.
  2. Find the variable you want to delete in the Name column and select in the Actions column.
  3. Dismiss the Variables panel.

Change variable values

If a dashboard has one or more variables, they are listed by name along the upper-left of the dashboard, under the dashboard name. When you change variable values, the dashboard contents are recalculated and displayed according to the new values.

To change the value of a variable

  1. In the upper-left of the dashboard, locate the variable name in the upper-left of the dashboards.

  2. Use the menu or edit box under the variable name to change the value.

    • If the variable allows just one selection (value) at a time, select the value that you want to apply to the dashboard.
    • If the variable allows multiple selections (values) at a time, select the checkbox for each value you want to apply to the dashboard. The menu name for that variable shows how many values are selected.
    • For a text variable, you can edit the text in the box under the variable name.

Query variable

To define a query variable

  1. Set Name the name you want to give your variable.
    • It will be displayed at the top of the dashboard, listed on the Variables panel, and referred to in code.
    • It can contain only letters (uppercase or lowercase) and numbers (for example, status, myHosts, or Variable01) and it can't start with dt_.
  2. Set Type to Query.
  3. In Definition, enter a query. Be sure to use summarize and collectDistinct to get distinct values from data sources such as logs.
  4. Select Run query and inspect the results in the Preview section to make sure it works as expected.
  5. If you want to be able to select more than one value at a time, turn on Multi-select.

If you add both examples below to your dashboard, you can filter your dashboard by host and log severity level. Be sure to turn on Multi-select if you want to select more than one at a time.

Example query variable 1

  • Name: Hosts
  • Type: Query
  • Definition: 
    fetch dt.entity.host
      | fields id

If you want to use a human-readable name, use | fields entity.name instead of | fields id.

Example query variable 2

  • Name: Loglevel
  • Type: Query
  • Definition: 
    fetch logs
      | fields loglevel
      | filterOut loglevel == "NONE"
      | summarize distinctLoglevels = collectDistinct(loglevel)
      | expand distinctLoglevels
      | sort distinctLoglevels asc

CSV variable

To define a CSV (comma-separated values) variable

  1. Set Name to the name you want to give your variable.

    • It will be displayed at the top of the dashboard, listed on the Variables panel, and referred to in code.
    • It can contain only letters (uppercase or lowercase) and numbers (for example, status, myHosts, or Variable01) and it can't start with dt_.

  2. Set Type to CSV.

  3. In Definition, enter a comma-separated list of possible values for this variable, such as dog, cat, horse.

    Be sure to use the correct value type. Dynatrace distinguishes values as numeric or string depending on how you specify them—with or without quotes. For example, 111 is a numeric value, while "111" is a string.

  4. Inspect the results in the Preview section to make sure it works as expected.

  5. If you want to be able to select more than one value at a time, turn on Multi-select.

    Your changes are saved automatically.

  6. Close the Variable panel.

Example CSV variable 1

This example would add a $Status variable to your dashboard with the ability to select more than one status at a time, and with four possible values: WARN, ERROR, INFO, NONE.

  • Name: Status
  • Type: CSV
  • Definition: 
    WARN, ERROR, INFO, NONE
  • Multi-select: on

Code variable

To define a code variable

  1. Set Name the name you want to give your variable.

    • It will be displayed at the top of the dashboard, listed on the Variables panel, and referred to in code.
    • It can contain only letters (uppercase or lowercase) and numbers (for example, status, myHosts, or Variable01) and it can't start with dt_.

  2. Set Type to Code.

  3. In Definition, enter the JavaScript code.

    For security reasons, when using variables in code tiles, you can only access them within the default function.

  4. Select Run query and inspect the results in the Preview section to make sure it works as expected.

  5. If you want to be able to select more than one value at a time, turn on Multi-select.

    Your changes are saved automatically.

  6. Close the Variable panel.

Example code variable 1

  • Name: CodeVariable
  • Type: Code
  • Definition: 
    /*
    * This will run JavaScript in the DYNATRACE
    * serverless environment.
    * To generate variable options return string array.
    */
    export default async function () {
    return ["val1", "val2", "val3"]
    }

Text variable

To define a text variable

  1. Set Name the name you want to give your variable.
    • It will be displayed at the top of the dashboard, listed on the Variables panel, and referred to in code.
    • It can contain only letters (uppercase or lowercase) and numbers (for example, status, myHosts, or Variable01) and it can't start with dt_.
  2. Set Type to Text.
  3. You can enter a Default value.

Limitations when using variables in tiles

  • Variables in your tiles can be of string or numeric type. Cases requiring a different data type (for example, duration) lead to failed queries. Below are some examples of how to work around such situations.
  • For security reasons, when using variables in code tiles, you can only access them within the default function.

Resolution in DQL command

Straightforward usage of a $resolution variable (as in the following query) doesn't work because resolution requires a predefined data format, while a variable returns a string value.

fetch logs
    | ...
    | summarize count(), by: {loglevel, bin(timestamp, $resolution)}

As a workaround, you can use the duration function together with a DQL conversion function. This provides the required output based on your $resolution value.

fetch logs
    | ...
    | summarize count(), by: {loglevel, bin(timestamp, duration(toLong($resolution), unit:"m"))}

Convert your variable values to other data types

If you want to filter a numeric value but compare it with a string representation, you can use a native DQL conversion function such as toString.

fetch logs
    | filter amount = toString($amount)
    | ...

Related topics