Documentation Plugins Infinity data source Query Macros

Macros

Macro functions are utility functions that perform operations and yield results based on the arguments provided. You can use macro function in the query URL, Body, Inline data, UQL, GROQ fields.

Following macros are available in this plugin

Custom Interval macro ($__customInterval())

Custom interval macro yields a value based on the dashboard time range. You can pass multiple condition and values to this macro. This acts like a If else condition in the programming languages.

Number of arguments to $__customInterval macro have to be 3/5/7/9..

Syntax : $__customInterval(duration1,value1,duration2,value2,duration3,value3,duration4,value4,defaultValue). Duration have to be valid duration syntax like 1m, 2d etc

Description : If dashboardTimeRange <= duration1 returns value1, Else if dashboardTimeRange <= duration2 returns value2, Else if dashboardTimeRange <= duration3 returns value3, Else if dashboardTimeRange <= duration4 returns value4, Else returns default value.

Example : $__customInterval(5m,foo,1d,bar,10d,baz,fuzz). If the dashboard time range is last 3 hours, then the result will be bar

More examples are given below

Combine Values macro ($__combineValues())

Combine values macro allows you to combine multiple string with prefix, suffix and in-between value. First parameter to this macro is prefix, Second param is the suffix and the third parameter is in-between value.

Minimum number of arguments required for this macro is 4. Number of arguments to this macro have to be 4/5/6/7…

For the prefix,suffix and in-between values you can also use following special escape words. __comma–>,/__space–> one blank space( )/__open–>(/__close–>).

Syntax : $__combineValues(prefix,suffix,in-between-value,value1,value2,value3)

Description : In the above example, all the value1, value2, value3 each will be attached with the prefix and suffix. Then everything will be concatenated by in-between-value.

Example : $__combineValues(key=,__space, OR ,value1,value2,value3) will yield key=value1 OR key=value2 OR key=value3. Note: in this example, we used a special escape suffix __space

There is a special nature to this macro where it returns empty string when there are four arguments and fourth argument is *

More examples are given below

This macro will be more useful when combined with the multi value dashboard variables. Consider the below example.

Variable Name: server

Multi value: true

Custom all value: true and the value is *

Time Macros (${__timeFrom} and ${__timeTo})

From v2.7.1, you can use time macros ${__timeFrom} and ${__timeTo} which will be interpolated in the backend. For example, if you have dashboard start time 2020-07-13T20:19:09.254Z, then the macros will be interpolated as following.

In infinity 2.7.1+, This is the preferred time macro over grafana global variable time macros (${__from} and ${__to}) due to the limitations of grafana global macros being handled in the frontend.