Query variable regex

[ebabeshko]

Ok, so this is your more or less expected result:

With flux it is pretty easy:

|> map(fn: (r) => {    
    tmp_ = regexp.replaceAllString(r: /^ILO/, t: "", v: regexp.replaceAllString(r: /^ILO0/, t: "0.", v: r["txt"]))
    num = regexp.replaceAllString(r: /_test$/, t: "", v: tmp_)
    return { r with num: num }
})

Not sure about InfluxQL though.

As for using variables in transformations, it is possible:

Just enable necessary feature toggle:

How can I try Datagrid visualization?

You can do some simple postprocessing by Grafana transformations. For example, you have the following data obtained from your datasource: [initial data] Using Filter by value transformation it is possible to filter data by variable value: [filtered data] As of now, to be able to use dashboard variables in this transformation, it is necessary to enable transformationsVariableSupport feature toggle: [feature_toggles] enable = transformationsVariableSupport