Logic group (filter)

These filtering operations are based on the standard Boolean operators AND, OR, and Not. AND and OR require at least two arguments, while Not requires only one argument. The arguments, or Operands, must be Boolean expressions.

These operations check columns with Boolean values to display only those that meet the conditions that you specify.

Prior to applying any of these filter operations, it is necessary to create new columns containing only Boolean values. These columns must correspond to the arguments that you will use when you define the filter.

1. And

Identifies the rows where the values in two or more specified columns are true. 

How does it work?

This operation requires at least two Operand arguments. You can add more as needed. 

Argument Data Type
Operand (mandatory) Boolean
Operand (mandatory) Boolean

Example

In the demo.ecommerce.data table, we want to display only those events where the bytes transferred are greater than 1000 and the time taken to send them is greater than 200.

Step 1: Create the dedicated columns with Boolean values

We need two new columns. One for the first condition (bytesTransferred>1000), and one for the second condition (timeTaken>200). Here is how we define these columns.

   

Once created, these columns will contain a TRUE or FALSE results for each condition.

Step 2: Apply the filter.

Select Filter on the query toolbar, then select AND as the operator. Now select the columns that you created as the Operands (arguments):  

  • Operand - timetaken>200 column

  • Operand - bytestransferred>1000 column

After applying the filter, the query displays only those rows where both timetaken>200 and bytestransferred>1000 values are true


If you choose negated instead of normal, the query will display all rows except those where the values in the specified columns are all true. In the above example, this means the query will display all rows where the values of the columns are true/false, false/true, and false/false.

2. Not

Identifies the rows where the value in the Boolean value column is false. 

How does it work?

This operation needs only one argument:

Argument Data Type
Operand (mandatory) Boolean

Example

We want to display only the rows where the method value is not GET.

Step 1: Create the dedicated column with Boolean values

We need to create a new column containing the Boolean value for method=GET. This column will contain either true or false. Here's how to define the column.


Step 2: Apply the filter

Select Filter on the query toolbar, then select Not as the operator. Now select the column that you created as the Operand (argument):  

  • Operand - method=GET column

After applying the filter, the query displays only the rows where the method value is not GET (method=GET is false).


3. Or

Identifies the rows where at least one of the values in two or more specified columns is true

How does it work?

This operation requires at least two Operand arguments. You can add more as needed. 

Argument Data Type
Operand (mandatory) Boolean
Operand (mandatory) Boolean

Example

In the demo.ecommerce.data table, we want to display those events where either the bytes transferred are greater than 1000 or the time taken to send them is greater than 200 (or both).

Step 1: Create the dedicated columns with Boolean values

See the step 1 instructions for the And operator example for instructions.

Step 2: Apply the filter.

Select Filter on the query toolbar, then select Or as the operator. Now select the columns that you created as the Operands (arguments):  

  • Operand - bytestransferred>1000 column

  • Operand - timetaken>200 column


After applying the filter, the query displays only those rows where either timetaken>200 is true or bytestransferred>1000 is true, or both are true.

Have we answered your question?

If not, please contact our technical support team via email by clicking the button below.

CONTACT US