Add and manage variables
The following table lists the types of variables shipped with Grafana.
Variable type | Description |
---|---|
Query | Query-generated list of values such as metric names, server names, sensor IDs, data centers, and so on. Add a query variable. |
Custom | Define the variable options manually using a comma-separated list. Add a custom variable. |
Text box | Display a free text input field with an optional default value. Add a text box variable. |
Constant | Define a hidden constant. Add a constant variable. |
Data source | Quickly change the data source for an entire dashboard. Add a data source variable. |
Interval | Interval variables represent time spans. Add an interval variable. |
Ad hoc filters | Key/value filters that are automatically added to all metric queries for a data source (Prometheus, Loki, InfluxDB, and Elasticsearch only). Add ad hoc filters. |
Global variables | Built-in variables that can be used in expressions in the query editor. Refer to Global variables. |
Chained variables | Variable queries can contain other variables. Refer to Chained variables. |
Enter General options
You must enter general options for any type of variable that you create.
Navigate to the dashboard you want to make a variable for and click the Dashboard settings (gear) icon at the top of the page.
On the Variables tab, click New variable.
Enter a Name for the variable.
In the Type list, select Query.
(Optional) In Label, enter the display name of the variable dropdown.
If you don’t enter a display name, then the dropdown label is the variable name.
Choose a Hide option:
- No selection (blank): The variable dropdown displays the variable Name or Label value. This is the default.
- Label: The variable dropdown only displays the selected variable value and a down arrow.
- Variable: No variable dropdown is displayed on the dashboard.
Add a query variable
Query variables enable you to write a data source query that can return a list of metric names, tag values, or keys. For example, a query variable might return a list of server names, sensor IDs, or data centers. The variable values change as they dynamically fetch options with a data source query.
Query variables are generally only supported for strings. If your query returns numbers or any other data type, you might need to convert them to strings in order to use them as variables. For the Azure data source, for example, you can use the tostring function for this purpose.
Query expressions can contain references to other variables and in effect create linked variables. Grafana detects this and automatically refreshes a variable when one of its linked variables change.
Note: Query expressions are different for each data source. For more information, refer to the documentation for your data source.
- Enter general options.
- In the Data source list, select the target data source for the query. For more information about data sources, refer to Add a data source.
- In the Refresh list, select when the variable should update options.
- On Dashboard Load: Queries the data source every time the dashboard loads. This slows down dashboard loading, because the variable query needs to be completed before dashboard can be initialized.
- On Time Range Change: Queries the data source every time the dashboard loads and when the dashboard time range changes. Use this option if your variable options query contains a time range filter or is dependent on the dashboard time range.
- In the Query field, enter a query.
- The query field varies according to your data source. Some data sources have custom query editors.
- Make sure that the query returns values named
__text
and__value
as appropriate in your query syntax. For example, in SQL, you can use a query such asSELECT hostname AS __text, id AS __value FROM MyTable
. Queries for other languages will vary depending on syntax. - If you need more room in a single input field query editor, then hover your cursor over the lines in the lower right corner of the field and drag downward to expand.
- (Optional) In the Regex field, type a regex expression to filter or capture specific parts of the names returned by your data source query. To see examples, refer to Filter variables with regex.
- In the Sort list, select the sort order for values to be displayed in the dropdown list. The default option, Disabled, means that the order of options returned by your data source query will be used.
- (Optional) Enter Selection Options.
- In Preview of values, Grafana displays a list of the current variable values. Review them to ensure they match what you expect.
- Click Add to add the variable to the dashboard.
Add a custom variable
Use a custom variable for a value that does not change, such as a number or a string.
For example, if you have server names or region names that never change, then you might want to create them as custom variables rather than query variables. Because they do not change, you might use them in chained variables rather than other query variables. That would reduce the number of queries Grafana must send when chained variables are updated.
- Enter general options.
- In the Values separated by comma list, enter the values for this variable in a comma-separated list. You can include numbers, strings, or key/value pairs separated by a space and a colon. For example,
key1 : value1,key2 : value2
. - (Optional) Enter Selection Options.
- In Preview of values, Grafana displays a list of the current variable values. Review them to ensure they match what you expect.
- Click Add to add the variable to the dashboard.
Add a text box variable
Text box variables display a free text input field with an optional default value. This is the most flexible variable, because you can enter any value. Use this type of variable if you have metrics with high cardinality or if you want to update multiple panels in a dashboard at the same time.
For more information about cardinality, refer to What are cardinality spikes and why do they matter?
- Enter general options.
- (Optional) In the Default value field, select the default value for the variable. If you do not enter anything in this field, then Grafana displays an empty text box for users to type text into.
- In Preview of values, Grafana displays a list of the current variable values. Review them to ensure they match what you expect.
- Click Add to add the variable to the dashboard.
Add a constant variable
Constant variables enable you to define a hidden constant. This is useful for metric path prefixes for dashboards you want to share. When you export a dashboard, constant variables are converted to import options.
Constant variables are not flexible. Each constant variable only holds one value, and it cannot be updated unless you update the variable settings.
Constant variables are useful when you have complex values that you need to include in queries but don’t want to retype in every query. For example, if you had a server path called i-0b6a61efe2ab843gg
, then you could replace it with a variable called $path_gg
.
- Enter general options.
- In the Value field, enter the variable value. You can enter letters, numbers, and symbols. You can even use wildcards if you use raw format.
- In Preview of values, Grafana displays the current variable value. Review it to ensure it matches what you expect.
- Click Add to add the variable to the dashboard.
Add a data source variable
Data source variables enable you to quickly change the data source for an entire dashboard. They are useful if you have multiple instances of a data source, perhaps in different environments.
In the Type list, select the target data source for the variable.
You can also click Open advanced data source picker to see more options, including adding a data source (Admins only). For more information about data sources, refer to Add a data source.
(Optional) In Instance name filter, enter a regex filter for which data source instances to choose from in the variable value drop-down list. Leave this field empty to display all instances.
(Optional) Enter Selection Options.
In Preview of values, Grafana displays a list of the current variable values. Review them to ensure they match what you expect.
Click Add to add the variable to the dashboard.
Add an interval variable
Use an interval variable to represents time spans such as 1m
,1h
, 1d
. You can think of them as a dashboard-wide “group by time” command. Interval variables change how the data is grouped in the visualization. You can also use the Auto Option to return a set number of data points per time span.
You can use an interval variable as a parameter to group by time (for InfluxDB), date histogram interval (for Elasticsearch), or as a summarize function parameter (for Graphite).
- Enter general options.
- In the Values field, enter the time range intervals that you want to appear in the variable drop-down list. The following time units are supported:
s (seconds)
,m (minutes)
,h (hours)
,d (days)
,w (weeks)
,M (months)
, andy (years)
. You can also accept or edit the default values:1m,10m,30m,1h,6h,12h,1d,7d,14d,30d
. - (Optional) Turn on the Auto Option if you want to add the
auto
option to the list. This option allows you to specify how many times the current time range should be divided to calculate the currentauto
time span. If you turn it on, then two more options appear:- Step count - Select the number of times the current time range will be divided to calculate the value, similar to the Max data points query option. For example, if the current visible time range is 30 minutes, then the
auto
interval groups the data into 30 one-minute increments. The default value is 30 steps. - Min Interval - The minimum threshold below which the step count intervals will not divide the time. To continue the 30 minute example, if the minimum interval is set to 2m, then Grafana would group the data into 15 two-minute increments.
- Step count - Select the number of times the current time range will be divided to calculate the value, similar to the Max data points query option. For example, if the current visible time range is 30 minutes, then the
- In Preview of values, Grafana displays a list of the current variable values. Review them to ensure they match what you expect.
- Click Add to add the variable to the dashboard.
Interval variable examples
The following example shows a template variable myinterval
in a Graphite function:
summarize($myinterval, sum, false)
The following example shows a more complex Graphite example, from the Graphite Template Nested Requests panel:
groupByNode(summarize(movingAverage(apps.$app.$server.counters.requests.count, 5), '$interval', 'sum', false), 2, 'sum')
Add ad hoc filters
Ad hoc filters enable you to add key/value filters that are automatically added to all metric queries that use the specified data source. Unlike other variables, you do not use ad hoc filters in queries. Instead, you use ad hoc filters to write filters for existing queries.
Note
Ad hoc filter variables only work with Prometheus, Loki, InfluxDB, and Elasticsearch data sources.
In the Data source list, select the target data source.
You can also click Open advanced data source picker to see more options, including adding a data source (Admins only). For more information about data sources, refer to Add a data source.
Click Add to add the variable to the dashboard.
Create ad hoc filters
Ad hoc filters are one of the most complex and flexible variable options available. Instead of a regular list of variable options, this variable allows you to build a dashboard-wide ad hoc query. Filters you apply in this manner are applied to all panels on the dashboard.
Configure variable selection options
Selection Options are a feature you can use to manage variable option selections. All selection options are optional, and they are off by default.
Multi-value variables
Interpolating a variable with multiple values selected is tricky as it is not straight forward how to format the multiple values into a string that is valid in the given context where the variable is used. Grafana tries to solve this by allowing each data source plugin to inform the templating interpolation engine what format to use for multiple values.
Note
The Custom all value option on the variable must be blank for Grafana to format all values into a single string. If it is left blank, then Grafana concatenates (adds together) all the values in the query. Something likevalue1,value2,value3
. If a customall
value is used, then instead the value will be something like*
orall
.
Multi-value variables with a Graphite data source
Graphite uses glob expressions. A variable with multiple values would, in this case, be interpolated as {host1,host2,host3}
if the current variable value was host1, host2, and host3.
Multi-value variables with a Prometheus or InfluxDB data source
InfluxDB and Prometheus use regex expressions, so the same variable would be interpolated as (host1|host2|host3)
. Every value would also be regex escaped. If not, a value with a regex control character would break the regex expression.
Multi-value variables with an Elastic data source
Elasticsearch uses lucene query syntax, so the same variable would be formatted as ("host1" OR "host2" OR "host3")
. In this case, every value must be escaped so that the value only contains lucene control words and quotation marks.
Troubleshoot multi-value variables
Automatic escaping and formatting can cause problems and it can be tricky to grasp the logic behind it. Especially for InfluxDB and Prometheus where the use of regex syntax requires that the variable is used in regex operator context.
If you do not want Grafana to do this automatic regex escaping and formatting, then you must do one of the following:
- Turn off the Multi-value or Include All option options.
- Use the raw variable format.
Include All option
Grafana adds an All
option to the variable dropdown list. If a user selects this option, then all variable options are selected.
Custom all value
This option is only visible if the Include All option is selected.
Enter regex, globs, or lucene syntax in the Custom all value field to define the value of the All
option.
By default the All
value includes all options in combined expression. This can become very long and can have performance problems. Sometimes it can be better to specify a custom all value, like a wildcard regex.
In order to have custom regex, globs, or lucene syntax in the Custom all value option, it is never escaped so you will have to think about what is a valid value for your data source.
Global variables
Grafana has global built-in variables that can be used in expressions in the query editor. This topic lists them in alphabetical order and defines them. These variables are useful in queries, dashboard links, panel links, and data links.
$__dashboard
Only available in Grafana v6.7+. In Grafana 7.1, the variable changed from showing the UID of the current dashboard to the name of the current dashboard.
This variable is the name of the current dashboard.
$__from and $__to
Grafana has two built-in time range variables: $__from
and $__to
. They are currently always interpolated as epoch milliseconds by default, but you can control date formatting.
Note
This special formatting syntax is only available in Grafana 7.1.2+
Syntax | Example result | Description |
---|---|---|
${__from} | 1594671549254 | Unix millisecond epoch |
${__from:date} | 2020-07-13T20:19:09.254Z | No args, defaults to ISO 8601/RFC 3339 |
${__from:date:iso} | 2020-07-13T20:19:09.254Z | ISO 8601/RFC 3339 |
${__from:date:seconds} | 1594671549 | Unix seconds epoch |
${__from:date:YYYY-MM} | 2020-07 | Any custom date format that does not include the : character. Uses browser time. Use :date or :date:iso for UTC |
The syntax above also works with ${__to}
.
You can use this variable in URLs, as well. For example, you can send a user to a dashboard that shows a time range from six hours ago until now: https://play.grafana.org/d/000000012/grafana-play-home?viewPanel=2&orgId=1?from=now-6h&to=now
$__interval
You can use the $__interval
variable as a parameter to group by time (for InfluxDB, MySQL, Postgres, MSSQL), Date histogram interval (for Elasticsearch), or as a summarize function parameter (for Graphite).
Grafana automatically calculates an interval that can be used to group by time in queries. When there are more data points than can be shown on a graph, then queries can be made more efficient by grouping by a larger interval. It is more efficient to group by 1 day than by 10s when looking at 3 months of data and the graph will look the same and the query will be faster. The $__interval
is calculated using the time range and the width of the graph (the number of pixels).
Approximate Calculation: (to - from) / resolution
For example, when the time range is 1 hour and the graph is full screen, then the interval might be calculated to 2m
- points are grouped in 2 minute intervals. If the time range is 6 months and the graph is full screen, then the interval might be 1d
(1 day) - points are grouped by day.
In the InfluxDB data source, the legacy variable $interval
is the same variable. $__interval
should be used instead.
The InfluxDB and Elasticsearch data sources have Group by time interval
fields that are used to hard code the interval or to set the minimum limit for the $__interval
variable (by using the >
syntax -> >10m
).
$__interval_ms
This variable is the $__interval
variable in milliseconds, not a time interval formatted string. For example, if the $__interval
is 20m
then the $__interval_ms
is 1200000
.
$__name
This variable is only available in the Singlestat panel and can be used in the prefix or suffix fields on the Options tab. The variable will be replaced with the series name or alias.
Note
The Singlestat panel is no longer available from Grafana 8.0.
$__org
This variable is the ID of the current organization.
${__org.name}
is the name of the current organization.
$__user
Only available in Grafana v7.1+
${__user.id}
is the ID of the current user.
${__user.login}
is the login handle of the current user.
${__user.email}
is the email for the current user.
$__range
Currently only supported for Prometheus and Loki data sources. This variable represents the range for the current dashboard. It is calculated by to - from
. It has a millisecond and a second representation called $__range_ms
and $__range_s
.
$__rate_interval
Currently only supported for Prometheus data sources. The $__rate_interval
variable is meant to be used in the rate function. Refer to Prometheus query variables for details.
$__rate_interval_ms
This variable is the $__rate_interval
variable in milliseconds, not a time-interval-formatted string. For example, if the $__rate_interval
is 20m
then the $__rate_interval_ms
is 1200000
.
$timeFilter or $__timeFilter
The $timeFilter
variable returns the currently selected time range as an expression. For example, the time range interval Last 7 days
expression is time > now() - 7d
.
This is used in several places, including:
- The WHERE clause for the InfluxDB data source. Grafana adds it automatically to InfluxDB queries when in Query Editor mode. You can add it manually in Text Editor mode:
WHERE $timeFilter
. - Log Analytics queries in the Azure Monitor data source.
- SQL queries in MySQL, Postgres, and MSSQL.
- The
$__timeFilter
variable is used in the MySQL data source.
$__timezone
The $__timezone
variable returns the currently selected time zone, either utc
or an entry of the IANA time zone database (for example, America/New_York
).
If the currently selected time zone is Browser Time, Grafana will try to determine your browser time zone.
Chained variables
Chained variables, also called linked variables or nested variables, are query variables with one or more other variables in their variable query. This section explains how chained variables work and provides links to example dashboards that use chained variables.
Chained variable queries are different for every data source, but the premise is the same for all. You can use chained variable queries in any data source that allows them.
Extremely complex linked templated dashboards are possible, 5 or 10 levels deep. Technically, there is no limit to how deep or complex you can go, but the more links you have, the greater the query load.
Grafana Play dashboard examples
The following Grafana Play dashboards contain fairly simple chained variables, only two layers deep. To view the variables and their settings, click Dashboard settings (gear icon) and then click Variables. Both examples are expanded in the following section.
Examples explained
Variables are useful to reuse dashboards and dynamically change what is shown in dashboards. Chained variables are especially useful to filter what you see.
Create parent/child relationship in a variable, sort of a tree structure where you can select different levels of filters.
The following sections explain the linked examples in the dashboards above in depth and builds on them. While the examples are data source-specific, the concepts can be applied broadly.
Graphite example
In this example, there are several applications. Each application has a different subset of servers. It is based on the Graphite Templated Nested.
Now, you could make separate variables for each metric source, but then you have to know which server goes with which app. A better solution is to use one variable to filter another. In this example, when the user changes the value of the app
variable, it changes the dropdown options returned by the server
variable. Both variables use the Multi-value option and Include all option, enabling users to select some or all options presented at any time.
app variable
The query for this variable basically says, “Give me all the applications that exist.”
apps.*
The values returned are backend
, country
, fakesite
, and All
.
server variable
The query for this variable basically says, “Give me all servers for the currently chosen application.”
apps.$app.*
If the user selects backend
, then the query changes to:
apps.backend.*
The query returns all servers associated with backend
, including backend_01
, backend_02
, and so on.
If the user selects fakesite
, then the query changes to:
apps.fakesite.*
The query returns all servers associated with fakesite
, including web_server_01
, web_server_02
, and so on.
More variables
Note
This example is theoretical. The Graphite server used in the example does not contain CPU metrics.
The dashboard stops at two levels, but you could keep going. For example, if you wanted to get CPU metrics for selected servers, you could copy the server
variable and extend the query so that it reads:
apps.$app.$server.cpu.*
This query basically says, “Show me the CPU metrics for the selected server.”
Depending on what variable options the user selects, you could get queries like:
apps.backend.backend_01.cpu.*
apps.{backend.backend_02,backend_03}.cpu.*
apps.fakesite.web_server_01.cpu.*
InfluxDB example
In this example, you have several data centers. Each data center has a different subset of hosts. It is based on the InfluxDB Templated dashboard.
In this example, when the user changes the value of the datacenter
variable, it changes the dropdown options returned by the host
variable. The host
variable uses the Multi-value option and Include all option, allowing users to select some or all options presented at any time. The datacenter
does not use either option, so you can only select one data center at a time.
datacenter variable
The query for this variable basically says, “Give me all the data centers that exist.”
SHOW TAG VALUES WITH KEY = "datacenter"
The values returned are America
, Africa
, Asia
, and Europe
.
host variable
The query for this variable basically says, “Give me all hosts for the currently chosen data center.”
SHOW TAG VALUES WITH KEY = "hostname" WHERE "datacenter" =~ /^$datacenter$/
If the user selects America
, then the query changes to:
SHOW TAG VALUES WITH KEY = "hostname" WHERE "datacenter" =~ /^America/
The query returns all servers associated with America
, including server1
, server2
, and so on.
If the user selects Europe
, then the query changes to:
SHOW TAG VALUES WITH KEY = "hostname" WHERE "datacenter" =~ /^Europe/
The query returns all servers associated with Europe
, including server3
, server4
, and so on.
More variables
Note
This example is theoretical. The InfluxDB server used in the example does not contain CPU metrics.
The dashboard stops at two levels, but you could keep going. For example, if you wanted to get CPU metrics for selected hosts, you could copy the host
variable and extend the query so that it reads:
SHOW TAG VALUES WITH KEY = "cpu" WHERE "datacenter" =~ /^$datacenter$/ AND "host" =~ /^$host$/
This query basically says, “Show me the CPU metrics for the selected host.”
Depending on what variable options the user selects, you could get queries like:
SHOW TAG VALUES WITH KEY = "cpu" WHERE "datacenter" =~ /^America/ AND "host" =~ /^server2/
SHOW TAG VALUES WITH KEY = "cpu" WHERE "datacenter" =~ /^Africa/ AND "host" =~ /^server/7/
SHOW TAG VALUES WITH KEY = "cpu" WHERE "datacenter" =~ /^Europe/ AND "host" =~ /^server3+server4/
Best practices and tips
The following practices will make your dashboards and variables easier to use.
Creating new linked variables
- Chaining variables create parent/child dependencies. You can envision them as a ladder or a tree.
- The easiest way to create a new chained variable is to copy the variable that you want to base the new one on. In the variable list, click the Duplicate variable icon to the right of the variable entry to create a copy. You can then add on to the query for the parent variable.
- New variables created this way appear at the bottom of the list. You might need to drag it to a different position in the list to get it into a logical order.
Variable order
You can change the orders of variables in the dashboard variable list by clicking the up and down arrows on the right side of each entry. Grafana lists variable dropdowns left to right according to this list, with the variable at the top on the far left.
- List variables that do not have dependencies at the top, before their child variables.
- Each variable should follow the one it is dependent on.
- Remember there is no indication in the UI of which variables have dependency relationships. List the variables in a logical order to make it easy on other users (and yourself).
Complexity consideration
The more layers of dependency you have in variables, the longer it will take to update dashboards after you change variables.
For example, if you have a series of four linked variables (country, region, server, metric) and you change a root variable value (country), then Grafana must run queries for all the dependent variables before it updates the visualizations in the dashboard.
Manage variables
The variables page lets you add variables and manage existing variables. It also allows you to inspect variables and identify whether a variable is being referenced (or used) in other variables or dashboard.
Move: You can move a variable up or down the list using drag and drop.
Clone: To clone a variable, click the clone icon from the set of icons on the right. This creates a copy of the variable with the name of the original variable prefixed with copy_of_
.
Delete: To delete a variable, click the trash icon from the set of icons on the right.
Filter variables with regex
Using the Regex Query option, you filter the list of options returned by the variable query or modify the options returned.
This page shows how to use regex to filter/modify values in the variable dropdown.
Using the Regex Query Option, you filter the list of options returned by the Variable query or modify the options returned. For more information, refer to the Mozilla guide on Regular expressions.
Examples of filtering on the following list of options:
backend_01
backend_02
backend_03
backend_04
Filter so that only the options that end with 01
or 02
are returned:
Regex:
/(01|02)$/
Result:
backend_01
backend_02
Filter and modify the options using a regex capture group to return part of the text:
Regex:
/.*(01|02)/
Result:
01
02
Filter and modify - Prometheus Example
List of options:
up{instance="demo.robustperception.io:9090",job="prometheus"} 1 1521630638000
up{instance="demo.robustperception.io:9093",job="alertmanager"} 1 1521630638000
up{instance="demo.robustperception.io:9100",job="node"} 1 1521630638000
Regex:
/.*instance="([^"]*).*/
Result:
demo.robustperception.io:9090
demo.robustperception.io:9093
demo.robustperception.io:9100
Filter and modify using named text and value capture groups
Note
This feature is available in Grafana 7.4+.
Using named capture groups, you can capture separate ’text’ and ‘value’ parts from the options returned by the variable query. This allows the variable drop-down list to contain a friendly name for each value that can be selected.
For example, when querying the node_hwmon_chip_names
Prometheus metric, the chip_name
is a lot friendlier than the chip
value. So the following variable query result:
node_hwmon_chip_names{chip="0000:d7:00_0_0000:d8:00_0",chip_name="enp216s0f0np0"} 1
node_hwmon_chip_names{chip="0000:d7:00_0_0000:d8:00_1",chip_name="enp216s0f0np1"} 1
node_hwmon_chip_names{chip="0000:d7:00_0_0000:d8:00_2",chip_name="enp216s0f0np2"} 1
node_hwmon_chip_names{chip="0000:d7:00_0_0000:d8:00_3",chip_name="enp216s0f0np3"} 1
Passed through the following Regex:
/chip_name="(?<text>[^"]+)|chip="(?<value>[^"]+)/g
Would produce the following drop-down list:
Display Name Value
------------ -------------------------
enp216s0f0np0 0000:d7:00_0_0000:d8:00_0
enp216s0f0np1 0000:d7:00_0_0000:d8:00_1
enp216s0f0np2 0000:d7:00_0_0000:d8:00_2
enp216s0f0np3 0000:d7:00_0_0000:d8:00_3
Note: Only text
and value
capture group names are supported.
Was this page helpful?
Related resources from Grafana Labs
![Getting started with the Grafana LGTM Stack](/static/assets/featured/getting-started-with-grafana-lgtm-stack-amer_featured.png?w=200 200w, /static/assets/featured/getting-started-with-grafana-lgtm-stack-amer_featured.png?w=400 400w)
![Getting started with Grafana dashboard design](/static/assets/featured/getting-started-with-grafana-dashboard-design_featured.png?w=200 200w, /static/assets/featured/getting-started-with-grafana-dashboard-design_featured.png?w=400 400w)
![Building advanced Grafana dashboards](/media/webinar/AMER_buildadv_notxt.png?w=200 200w, /media/webinar/AMER_buildadv_notxt.png?w=400 400w)