Conditions

In the context of data filtering, "conditions" are specific criteria used to determine which data points should be included or excluded from a dataset. A condition functions as a rule that the data must satisfy to be displayed or processed within a filter. Conditions are fundamental to the operation of data filters, as they provide the necessary logic to segment and refine data according to user-defined requirements.

Each condition typically involves a comparison between a data attribute (such as a column value) and a specified criterion. This comparison can take various forms, such as:

• Equality: Checks if the data attribute equals a certain value (e.g., "Status equals Active").

• Inequality: Determines if the data attribute does not equal a specific value (e.g., "Campaign type does not equal Sponsored brands").

• Range: Assesses if the data attribute falls within a specified range (e.g., "Sales is greater than $20 and less than $100").

• Containment: Evaluates if the data attribute contains, begins with, or ends with a certain string or value (e.g., "Ad group name begins with 'B0'").

The selection and combination of these conditions enables you to build complex filters tailored to your analytical needs. By applying conditions, you can focus on relevant data subsets, making it easier to analyze trends, identify patterns, and derive insights from large datasets. Conditions are a vital component in data management and analysis tools, providing the flexibility and precision needed for effective data exploration.

Available conditions

The filters interface allows you to set the following conditions for each set of parameters:

• Equals: This condition filters the data to show records that exactly match a specified value.

• Does not equal: This filters out any records that match a specified value, showing only those that are different.

• Begins with: Displays records where the specified field starts with a certain character or string.

• Does not begin with: Excludes records where the specified field starts with a particular character or string.

• Ends with: Filters to show records where the specified field ends with a certain character or string.

• Does not end with: Excludes records where the specified field ends with a particular character or string.

• Contains: Shows records that include a certain character, word, or string in the specified field.

• Does not contain: Filters out records that include a particular character, word, or string in the specified field.

• Is greater than: Displays records where the value in the specified field is higher than the set value.

• Is greater than or equal to: Shows records where the value in the specified field is equal to or greater than the set value.

• Is less than: Filters to display records where the value in the specified field is less than the set value.

• Is less than or equal to: Shows records where the value in the specified field is equal to or less than the set value.

• Is blank: Filters to display records where the specified field has no data.

• Is not blank: Shows records where the specified field contains any data.