Example

In the demo.ecommerce.data table, suppose you want to view only those events with data transfer times that are 700 or more. Select Filter from the query toolbar, then select Greater or equal as the operation. The arguments needed are:

Value - timeTaken column

is greater or equal to - 700

After applying the filter, the query displays only the rows where the timeTaken value is greater than or equal to 700.

3. Greater than

Filters those events where one value is greater than either another field of the same data type or a specified value.

Example

In the demo.ecommerce.data table, suppose you want to display only those events where the number of bytes sent is greater than 800. Select Filter from the query toolbar, then select Greater than as the operation. The arguments needed are:

Value - bytesTransferred column

is greater than - 800

After applying the filter, the query displays only the rows where the bytesTransferredvalue is greater than 800.

4. Less or equal

Filters those events where one value is less than or equal to another field of the same data type or a specified value.

Example

To display only the status codes that are less than or equal to 400 in the demo.ecommerce.data table, click Filter on the query toolbar, then select Less or equal as the operation. The arguments needed are:

Value - statusCode column

is less than or equal to - 400

After applying the filter, only the rows where the the statusCodevalue is less than or equal to 400 are displayed.