The where command can be used to complete the search below.
… | where failure>successes
The where command is a search command that allows you to filter events based on complex or custom criteria. The where command can use any boolean expression or function to evaluate each event and determine whether to keep it or discard it. The where command can also compare fields or perform calculations on fields using operators such as >, <, =, +, -, etc. The where command can be used after any transforming command that creates a table or a chart.
The search string below does the following:
It uses … to represent any search criteria or commands before the where command.
It uses the where command to filter events based on a comparison between two fields: failure and successes.
It uses the greater than operator (>) to compare the values of failure and successes fields for each event.
It only keeps events where failure is greater than successes.