3653244 - What is the difference between the AND/OR conditions when building a advanced filter?

Symptom

Advanced filtering mainly uses AND or OR conditions to filter the data fields.
These conditions can be set to Include or Exclude the data that satisfies the filter conditions.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP SuccessFactors HCM Suite

Resolution

Currently, advanced filtering can be used on both queries and stories. You can apply an advanced filter for an entire story page or on individual widgets. The option for advanced filters is enabled only after you add at least one table to the query canvas or one chart to the story page.

The OR operator will be used to execute the filter when any of the following conditions are met.

On the other hand, the AND operator will execute the filter when all of the following conditions are met.

To toggle between the AND/OR operators, you'll just need to click on dropdown menu below the "Conditions" title, and choose the desired operator.

Examples:

On the scenario below, the filter will work when any condition is satisfied. In this case, it would be active users, or users that are located on the Americas time zone.

If we change the operator to AND, only users that are active and located on the Americas time zone will be displayed in the Report.

Keywords

Story, Story Reports, Stories, filter, filtering, advanced filter, conditions, filter conditions, and, or, and/or, difference, difference between, difference between and/or , KBA , LOD-SF-ANA-SAC-DAM , Data Modelling - Module & Entity Data Issues , How To

Product

SAP SuccessFactors HCM Suite all versions