How to generate a "less than" filter in a dashboard?

[qxu5715]

I want to build a dashboard with a text input as a filter, that shows all values in a field which are less than XX. I wanna do it with a textbox as input, cause the column includes values between 0 and 1677215.

e.g.: If i write 20000 in the textbox, the dashboard should show me all values less (or equal) 20000.

I've tried to escape the "<" expression with "& lt;" , but that didn't work (the space between & and l is, of course, not in my sourcode, but just here).

[renjith_nair]

Hi @qxu5715,

This is a run anywhere example

<dashboard>
  <label>Test1</label>
  <fieldset submitButton="false">
    <input type="text" token="limit" searchWhenChanged="true">
      <label>limit</label>
    </input>
  </fieldset>
  <row>
    <panel>
      <table>
        <search>
          <query>index=_*|stats count by sourcetype|where count<$limit$</query>
          <earliest>-15m</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
      </table>
    </panel>
  </row>
</dashboard>

[niketn]

@qxu5715 for us to assist you better please provide little bit more detail of what you have tried. What is the Simple XML code for Text Box and Search Query you are using.

Please mask/anonymize any sensitive information that you may have!

[gcusello]

Hi qxu5715,
in your code use < instead <
Bye.
Giuseppe