You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Adding AND/OR Logical Operator to BI Report Filters

Received Response
61
Views
2
Comments

Summary:

Does anyone know how to add the ADD or OR logical operator to multiple BI report filters?

Content (required):

I created an enrollment report using the BI Reporting feature in the LearnCentre.

When you edit a BI report, you can add filters to filter the data in select report fields.

I want to find all enrollments in the LearnCentre that contain either the word "bias" or "ally" in the Enrollment Name field.

I created the following filters:

Filter 1: Enrollment Name LIKE %bias%

Filter 2: Enrollment Name LIKE %ally%

There's no option on the Filters screen to apply a logical operator (AND or OR) to the filters. Running the report as is will not return any data.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!