Repeating panel: how to use a variable as the key to another variable?

[felipefischmann]

• What Grafana version and what operating system are you using?
  v8.0.3 Windows

• What are you trying to achieve?
  I have 2 variables.
  Variable1: FOO,BAR,BAS,
  Variable2: A MSSQL query that returns a key-value pair such as FOO_ETC:12, BAR_ETC:12
  I have a panel that repeats for each value in Variable1, which is used in most queries.
  I would like to add a query using the respective value of Variable2: so for example in the FOO panel instance, use the value 12.
  I know that if the panels were repeating on Variable2 instead of 1, I could get that value easily with {Variable2:value}. However, I have to use Variable1 (because in some cases Variable2 doesn’t have an entry but I still want to show the other queries).
  I’d think it would be possible to somehow, for each panel instance:

1. Create the corresponding Variable2 string, based on the value of Variable1 - this is possible with “${Variable1}_ETC” → “FOO_ETC”
2. Use the string above to access the corresponding value of Variable2. Really just like using a key in a dictionary. In Python terms for example, as Variable2[“FOO_ETC”]. But I’m not aware of this being possible in key-value variables in Grafana.

• How are you trying to achieve it?
  I’ve read a lot of questions and documentation but couldn’t come up with anything to get started.

• What happened?
  N/A

• What did you expect to happen?
  N/A

• Can you copy/paste the configuration(s) that you are having problems with?
  See above

• Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
  Didn’t get to this point

• Did you follow any online instructions? If so, what is the URL?
  N/A

[mattabrams]

Generally speaking, @felipefischmann, you will want to explore chained variables. Check out this doc and the linked examples. The example dashboard are a great starting point for building your own template:

Chained variables

[felipefischmann]

Thanks @mattabrams
I did have a look into chained variables but it doesn’t seem to be exactly what I need.
My understanding is that with chained variables the idea is to use values from one variable to filter values from another variable, on the dashboard level.
What I need to achieve is, within a query, access a single value of a variable (12) by using as a key a string (“FOO_ETC”) that is built using another variable value (“FOO”)

[mattabrams]

hmmm, you can create key:value pairs using custom type variables. Maybe there is a sequence here but I’m not sure…