I am building a dashboard that has 2 query variables (from influxDB). The defaulted values are all for both. The dashboard has a single stat panel repeated for storeid. When all is selected for storeid and status, it displays correctly as shown below:
However, when I select only one value for status, the dashboard shows correct (sort of) but panels are not being hidden. Both query values are shown as: include all/include mutiple values.
The query itself is written as below: SELECT overallstatus FROM “summary_data” WHERE storeid =~ /^storeid/ and overallstatusstr =~ /^status/
In second case, I do not wish to show stores where status is not one of selected. How do I achieve this?