[Data Prep and Transformation] When should a Prism configurator leverage advanced filter logic over basic filter logic?

Advanced filter logic in Workday Prism Analytics is specifically required when you need to construct complex filter conditions that involve a combination of AND and OR operators. Basic filter logic implicitly joins all conditions with an AND operator. To create more nuanced filtering, such as (Condition A AND Condition B) OR Condition C, the configurator must switch to the advanced logic view to manually define the relationship between the different filter criteria using parentheses and the appropriate logical operators.

A. Removing NULL values is a fundamental filtering operation that can be accomplished using basic filter logic with operators like "is empty" or "is not empty".
B. Operators such as "equal to" or "not equal to" are standard comparison operators available within the basic filter logic interface.
C. Operators like "greater than or equal to" or "less than or equal to" are also standard comparison operators available in basic filter logic.

1. Workday, Inc. (2023). Prism Analytics: Prepare Data.

Section: Filter Stage. This document details the functionality of the Filter stage in data preparation. It explicitly states, "By default, Workday connects all filter conditions with an AND operator. To use OR logic or a combination of AND and OR logic, you must enable Advanced Logic." This directly confirms that combining AND/OR operators is the specific use case for advanced logic. The document also shows that basic filtering includes options for handling NULLs and using standard comparison operators like "equal to," "not equal to," "greater than," and "less than."