Grafana template variable

Hello,

How can I create Chained or Linked Variables using flux in “Grafana Variables”?
Using influxql
1)
I have the first variable called Site_Name (pull it from the query)
SHOW TAG VALUES WITH KEY=“Site”

Second variable called Env (pull it from the query based on filter using Site_Name)
SHOW TAG VALUES WITH KEY=“Environment” WHERE Site =~ /$Site_Name/

Currently i query tag values like given below… but not sure how to link them

import “influxdata/influxdb/v1”
v1.tagValues(
bucket: v.bucket,
tag: “Site”,
predicate: ® => true
)

import “influxdata/influxdb/v1”
v1.tagValues(
bucket: v.bucket,
tag: “Environment”,
predicate: ® => true
)

Hi @martinfalch,
I went through the github issue: https://github.com/grafana/grafana/issues/26780#issuecomment-709314745

Did you find a solution to chain variables?