Grafana mysql multiple value variable

Question

I am having two variables in grafana for data source MySql, one is Site where i have enabled multi value option and second is Topic. Now i want that if we select multiple values in Site variable, Topic variables should reflect those changes but that's not working.

Table i am using is this -

Although normal query in mysql is working - sql query i wrote which is working fine -

select topic from problems_solved where Site in (select Site from problems_solved)

But in grafana its not working. I am trying this query - select topic from problems_solved where Site in(select ${Site} from problems_solved). I tried with other queries are well but its not working. Can somebody help me out here.

Thanks

Site = ${Site} expect only one value. What is the error in grafana for your working query ? — Ergest Basha
– Ergest Basha, Commented Oct 9, 2021 at 19:16
Yeah, that true. For grafana i am not getting any error only not seeing data. Can you wrote query for that. I am not able to figure out how to write query for this. — Pratik das baghel
– Pratik das baghel, Commented Oct 9, 2021 at 19:29
I am using only one table. Edited question as per as your comments. — Pratik das baghel
– Pratik das baghel, Commented Oct 9, 2021 at 19:45

Jan Garaj · Accepted Answer · 2021-10-09 20:15:35Z

8

Use variable fomating, which creates correct SQL syntax (and more effective approach + remove duplicates). You can use Grafana advanced variable format options. Example:

1.) Site variable:

SELECT DISTINCT Site 
FROM problems_solved

2.) Topic variable:

SELECT DISTINCT topic 
FROM problems_solved
WHERE Site IN (${Site:sqlstring})

answered Oct 9, 2021 at 20:15

Jan Garaj

29k3 gold badges49 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Grafana mysql multiple value variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related