How to set variables?

[landyliu]

Hi sir,

I would like to know how to set the variables in Grafana.
I tried but still can’t not work successfully.
Please reference the screen shot down below.

“This variable is not referenced by any variable or dashboard”

Current status

Setting:

Previous display:

Select query: AMD, bar chart didn’t change.
I would like to know how to set the variables to query successfully.

BR, Landy

[sowdenraymond]

you need to reference your variable as ${Customer}

You created a variable called Customer, then in your sql statement, you are fetching customer_name and grouping by customer_name, but nowhere do you reference your variable Customer…

[landyliu]

hi sowdenraymond,

Thank you for your reply. I tried successfully.