Pass value from query variable to a custom dashboard variable

[krishnasaxena69]

I have created a query variable named id which returns three values Year,Month,QTR

I have created another custom variable and want to pass the value selected from the id variable to my custom variable.

But in the query inspector, the value is not getting passed.

How can I achieve it

[ebabeshko]

I had the same issue when several queries were specified in a custom variable, looks like it’s not possible to use variables there.

Change Grafana query dynamically based on user inputs

hi @ldrascic , thank you for your solution. I also use InfluxDB (Flux) and everything works fine until Flux queries include other variables. For example, I have a variable test_var: [query] And I use it in my query so as to parametrize it (variable Query): CPU : from(bucket: "test") |> range(start: v.timeRangeStart\, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "cpu") |> filter(fn: (r) => r["_field"] == "usage_idle") |> filter(fn: (r) => r["cpu"] == "cpu-total") |> aggr…

Could you confirm that if you use query from Metric variable instead of ${Metric} in this panel everything works as expected (i.e. $id is replaced by ‘QTR’ or other selected value)?

[yosiasz]

dont use inline metric queries but rather use stored pricedures and pass the variables to the stored proc
As is that 2nd variable is unreadable and unmaintainable.

maybe use a mock table query

select 'QTR' as __text,
 'call quarterly()' as __value

from mysql doc

Stored procedures offer a significant performance advantage over ad-hoc SQL queries .