In my dashboard, I have a set of values I am trying to select via checkboxes. However - I may only have values in one of the checkbox lists.
If any of the inputs are null, the search is malformed, and doesn't work. How can I either ignore the NULL field, or merge the results cleanly to search?
<form>
<label>Dashboard</label>
<description>Dashboard</description>
<fieldset submitButton="true">
<input type="time" token="field1">
<label></label>
<default>
<earliest>@d</earliest>
<latest>now</latest>
</default>
</input>
<input type="checkbox" token="field2">
<label>NY Hosts</label>
<choice value="aa">aa</choice>
<choice value="bb">bb</choice>
<delimiter> OR </delimiter>
<valuePrefix>Host=</valuePrefix>
</input>
<input type="checkbox" token="field3">
<label>UK Hosts</label>
<choice value="cc">cc</choice>
<choice value="dd">dd</choice>
<choice value="ee">ee</choice>
<delimiter> OR </delimiter>
<valuePrefix>Host=</valuePrefix>
</input>
<input type="checkbox" token="field4">
<label>HK Hosts</label>
<choice value="ff">ff</choice>
<choice value="gg">gg</choice>
<delimiter> OR </delimiter>
<valuePrefix>Host=</valuePrefix>
</input>
</fieldset>
<row>
<panel>
<chart>
<title>Graph1</title>
<search>
<query>index=index $field2$ OR $field3$ OR $field4$ |timechart min(Value) by Host limit=0</query>
<earliest>$field1.earliest$</earliest>
<latest>$field1.latest$</latest>
</search>
</chart>
</panel>
</row>
... View more