Resolved:Selecting disk measurement for templating

the syntax works but i had to remove the panel and re add then it worked…

Hi I am using influxdb and grafana
I want to template disk panel based on the disks assign to the host. I can seem to get it right. Here is my query which is not working.
SHOW MEASUREMENTS WITH MEASUREMENT =~ /_capacity/ where host ='/[[host]]/'
in influxdb
SHOW MEASUREMENTS WITH MEASUREMENT =~ /_capacity/ where host ='hostname'

returns the correct output but not in grafana.