How to write a conditional search to return a table if the value of a field is X, else, it shouldn't be displayed?

[rongruspe]

How to have a search that returns a table if the value of a specific field is X, else, it shouldn't be shown.

Name......Value
A..............3
B..............5
C..............20

IF: Value > 10

Name.....Value
C.............20

[woodcock · Accepted solution]

Add this:

... | where Value > 10

[rongruspe]

Thanks! Been trying eval and stats. Wasn't able to run through the where clause. Thanks!