Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, filtering a derived dataset to meet specific criteria involving multiple conditions with mixed logical operators (AND, OR) requires careful configuration. The criteria here are: Agent ID is not null AND (Location is Dallas OR Location is Montreal). According to the official Workday Prism Analytics study path documents, this can be achieved by using Advanced Filter conditions (option C).
A Simple Filter in Prism Analytics allows for basic conditions with a single operator ("If All" for AND, "If Any" for OR), but it cannot handle nested logic like AND combined with OR in a single filter. For example, a Simple Filter with "If All" would require all conditions to be true (Agent ID is not null AND Location is Dallas AND Location is Montreal), which is too restrictive. A Simple Filter with "If Any" would include rows where any condition is true (Agent ID is not null OR Location is Dallas OR Location is Montreal), which is too broad. The Advanced Filter, however, allows for complex expressions with nested logic, such as ISNOTNULL(Agent_ID) AND (Location = "Dallas" OR Location = "Montreal"), ensuring the correct rows are included.
The other options are incorrect:
A. By adding a Manage Fields stage: The Manage Fields stage modifies field properties (e.g., type, visibility) but does not filter rows based on conditions.
B. By using Simple Filter conditions: As explained, a Simple Filter cannot handle the combination of AND and OR logic required for this criteria.
D. By creating a Custom Example: Custom Examples are used to provide sample data for testing, not to filter rows in a dataset.
Using Advanced Filter conditions allows for the precise application of the required logic to filter the dataset accurately.
[References:, Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Filtering Data in Derived Datasets, Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Using Advanced Filters for Complex Conditions, , ]
