Value is a field. Fields won’t automatically appear in the Query Editor’s Where Clause. (The Query Editor UI is filling the drop down list with a SHOW TAG KEYS query to InfluxDB.) That is why you only see “DeviceID” in the drop down.
One can still enter a field comparison into the Where Clause of the Query Editor UI by just typing the Field Name in the text box. I know this works for numeric comparisons. I don’t recall if it works for Booleans. (The query shown in the first post looks like the correct query–it looks like Grafana kept true a Boolean and did not convert true to a string. That should have worked…)
In any event, when I tried this, I skipped the Query Wizard. I manually typed in the query (I selected the pencil icon and typed the query into the text box). That worked.
I’m not positive I follow your description of how the STAT panel is configured. However, it sounds like it is working, because Value is a field.
Did I answer the correct question?
