Filters
Access requirements
Permission with these capabilities: Change Analysis Context
Reach out to your administrator for access.
Overview
Tip: Watch this video to learn how to apply filters.
Filtering is essential to conducting ad hoc analysis and allows you to view a smaller part of your data set. When applying a filter, you're choosing one or more values of an attribute to include or exclude from your view. For example, if you want to analyze data for employees located in North America, you would only select the North America value from the Location Hierarchy attribute to include in your view. You'll notice that we've grouped attributes by category so they're easier to find when filtering. For example, the Location Hierarchy attribute is found under the Organization category.
Add filters to change the analysis context for your visualizations and analyses. For instructions, see Add a Filter and Advanced filters..
Key terms
Use these terms to understand how filters define your analysis population.
|
Term |
Definition |
Example |
|---|---|---|
|
Filter |
A rule that includes or excludes subject members based on the values of one attribute. |
Location Hierarchy: North America shows data only for employees in North America. |
|
Attribute |
A characteristic of an object. For more information, see Attributes. |
Attributes of Employee include Gender, Tenure, and Manager Status. |
|
Attribute value |
One value of an attribute. |
Canada is a value of Location Hierarchy. Level 4 is a value of Performance Rating. |
|
Include or exclude |
Whether the filter keeps or removes subject members with the selected attribute values. |
Including Canada in Location Hierarchy shows only employees in Canada. Excluding Canada shows everyone except employees in Canada. |
|
Operator |
How two or more filters combine. The |
Organization: HR |
|
Advanced filter |
A filter type that combines filters and filter groups with |
Organization: HR |
|
Filter group |
A set of filters inside an advanced filter that is evaluated first, like an expression in parentheses. |
In (Location: Canada |
|
Key group |
A saved set of filters you can reuse. For more information, see Groups and Key Groups. |
You save the HR Staff advanced filter as a key group so you can quickly apply it when analyzing data. |
Operators
An operator determines how filters combine to define the population.
and: Includes subject members who meet every condition. Each filter you add narrows the population.or: Includes subject members who meet at least one condition. Each filter you add expands the population.
Each subject member appears in the population once, even if they meet more than one condition.
|
Operator |
How to set it up |
Example |
Population |
|---|---|---|---|
|
|
Add filters, or select |
Organization: HR |
Only employees in the HR organization whose job function is also HR. |
|
|
Select |
Organization: HR |
Employees in the HR organization, employees with an HR job function, and employees who meet both conditions. |
You can combine multiple filters using or and and operators.
If you want to define the order of operations, use filter groups when building an advanced filter.
Filter types
You can define your analysis population with filters or advanced filters. Both types filter subject members, such as employees, applicants, and requisitions, based on their attribute values.
- Filter: Shows only the subject members who match every filter you add. Each filter you add makes your population narrower.
- Advanced filter: Combines filters and filter groups using
andandoroperators. This allows you to define populations that span multiple attributes or parts of your organization.
Use the following guidance to choose which filter type to build for your analysis population.
|
Filter type |
When to use it |
Typical examples |
|---|---|---|
|
Filter |
|
|
|
Advanced filter |
|
|
When you add more than one filter, the filters combine with and. The population includes only subject members who match every filter. However, some populations don't follow your organization's structure. A person's role is often defined by a combination of attributes, not one attribute. For example, use an advanced filter to capture everyone in the HR organization or everyone with an HR job function, so you include HR staff who sit in other departments.
Note: Selecting more than one attribute value in a single filter includes subject members who match any of those values. For example, Location: Canada, United States includes employees in either country.
Advanced filters
An advanced filter is made up of:
- Filter: An attribute and the values you select, such as Location: Canada.
- Filter group: A set of filters that is evaluated together before it is combined with the rest of the advanced filter. Use a filter group when you need both
andandorin the same advanced filter.
Note: In each filter group, you can use each attribute once. You can use the same attribute in different filter groups. Filter groups cannot be added inside other filter groups.
How operators work in advanced filters
The first operator you choose at a level applies to everything you add to that level. The top level is everything that isn't inside a filter group. For example, if you join your first two filters with or, the next filter you add also uses or. If you change the operator to and, all of the filters change to and.
To use both and and or, put some of your filters in a filter group. A filter group can use a different operator than the rest of the advanced filter.
Example: Include everyone in HR, plus Analytics employees in Canada.
- Add the filter Organization: HR.
- Add a filter group with Job Function: Analytics
andLocation: Canada. - Join the filter and the filter group with
or.
Advanced filter limitations
Advanced filters cannot be applied to:
- Movement Breakdown Visual
- Movement Summary Visual
- Movement metrics
- Metrics based on a lookup overlay
- Security filters: Advanced filters cannot be used to define the population of the analytic object that users can access in a permission.
Advanced filters are partially supported in:
- Vee: Vee can explain an analysis or visualization that uses an advanced filter, but cannot answer follow-up questions about it.
- Dynamic analyses: You can only use advanced filters through key groups, and only when viewing the visualization.
- Cohorts: You cannot use the
oroperator in a cohort that contains filters based on changes. - Reports: Advanced filters in reports cannot have a display name.
- Key groups: You cannot save an advanced filter that contains a saved cohort as a key group.
Filter examples
The following examples use this sample of Employee data.
|
Employee |
Organization |
Job Function |
Location |
|---|---|---|---|
|
Ana |
HR |
HR |
Canada |
|
Ben |
HR |
Analytics |
United States |
|
Chen |
Engineering |
Analytics |
Canada |
|
Dana |
Manufacturing |
HR |
United States |
|
Eli |
Sales |
Sales |
United Kingdom |
|
Example |
Filter |
Result |
|---|---|---|
|
Employees in the HR organization who also have an HR job function |
Organization: HR |
Included: Ana |
|
Everyone in the HR organization, plus anyone with an HR job function |
Organization: HR |
Included: Ana, Ben, and Dana |
|
Employees in the HR organization in the United States, plus Analytics employees in Canada |
(Organization: HR |
Included: Ben and Chen |
|
Everyone in the HR organization, plus Analytics employees in Canada |
Organization: HR |
Included: Ana, Ben, and Chen |
|
Employees in the HR organization or employees with an Analytics job function, but only in Canada |
(Organization: HR |
Included: Ana and Chen |
Best practices
- Start with filters. Use an advanced filter only when you need
orbetween different attributes. - Define the population in a sentence first. For example: all HR employees, plus Analytics employees in Canada. Use the sentence to decide which filters belong together and which operator joins them.
- Group filters that must be true together. A filter group makes the order of operations clear to viewers.
- Name your filters. Short display names are easier to read than the full filter definition in the analysis context.
- Save populations you reuse as key groups. Key groups can be reused across different filtering workflows.
- Verify the population. Use View Details to confirm the right subject members are included.