Metrics based on variable value

[gvocca]

Dear all,
first of all let me thank Grafana developers, it is an impressive work making data representation much easier.
Coming to the question: I need to display more that one metric in one panel and currently I use multiple queries. As not all of them are needed at the same time, is there any way to calculate and display the metrics according to the checkbox in a custom variable ?
My data source is MySQL

Thank you for your support
Gaetano

[danielgonzalez]

Yes it is possible!!
you can see a example

Using Variables to dynamically select Columns in MySQL

This is how it looks when its not working. [image] this is the autogenereated query when using the variables, and when “multi-select” is activated SELECT zeit AS "time", 'Machine4711','Machine1438','Machine1234','Machine5475' FROM machinenzustandstabelle ORDER BY zeit It seems like it adds those " ’ ", and this is against the Syntax of mysql. If multi-value is not selected i get the correct autogenerated query SELECT zeit AS "time", Machine4711,Machine1438,Machine1234,Machine5475 …

[gvocca]

Thank you Daniel, I’l go and check it!