How to use custom variable value in measurement inside bucket

[anjali07]

import “strings”
data
|> map (fn:(r) => ({
r with
names_1: strings.split(v: r.name, t: “,”)[0],
names_2: strings.split(v: r.name, t: “,”)[1]
}))
from(bucket: “BATQABucket”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r._measurement ==“r.names_1”)
How to use name_1 variable inside _measurement.

[yosiasz]

Is this different than

I want to implement multi selection in Grafana with influx query

Hi @anjali07 That is indeed tricky and I did not figure it out until recently. One has to format like this in the Flux query: |> filter(fn: (r) => r["region"] =~ /^${region:regex}$/ ) or if using InfluxQL, like this: ...WHERE ("type"::tag = 'Demand' AND "region"::tag =~ /^$region$/) AND ... Screenshots: [image] query for above: from(bucket: "EIAtest7") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "ElectricPowerOperations") |>…

[anjali07]

yes, it’s different.

[grant2]

@anjali07

How to use name_1 variable inside _measurement.

I think this may help.