Filters

Fundamental concepts, filter logic, and best practices for creating effective filters to narrow your data to a specific analysis population.

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 and operator requires every filter to be true. The or operator requires at least one filter to be true.

Organization: HR and Job Function: HR, the and operator requires both of these rules to be true, employee must be in the HR organization and their job function is HR.

Advanced filter

A filter type that combines filters and filter groups with and or or operators to define complex populations.

Organization: HR or Job Function: HR, which captures anyone in the HR organization as well as employees in other departments who have an HR job function.

Filter group

A set of filters inside an advanced filter that is evaluated first, like an expression in parentheses.

In (Location: Canada and Job: Manager) or Location: Singapore, the filters in parentheses are a filter group.

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

and: All conditions must be true

Add filters, or select and in an advanced filter

Organization: HR and Job Function: HR

Only employees in the HR organization whose job function is also HR.

or: At least one condition must be true

Select or in an advanced filter

Organization: HR or Job Function: 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 and and or operators. 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

  • You're filtering on straightforward attribute values, such as including or excluding specific categories, levels, or ranges.
  • Your conditions across different attributes must all be true. For example, Department: Sales and Location: Canada.
  • Your conditions within the same attribute can match any of the selected values.
  • Active employees in North America.
  • Employees with base pay under $65,000.
  • All employees except contractors.

Advanced filter

  • You need or logic across different attributes.
  • You need to combine and and or in a single rule.
  • Employees in the HR organization, plus anyone with an HR job function.
  • Employees in the HR organization in the United States, plus Analytics employees in Canada.

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 and and or in 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.

  1. Add the filter Organization: HR.
  2. Add a filter group with Job Function: Analytics and Location: Canada.
  3. 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 or operator 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 and Job Function: HR

Included: Ana

Everyone in the HR organization, plus anyone with an HR job function

Organization: HR or Job Function: HR

Included: Ana, Ben, and Dana

Employees in the HR organization in the United States, plus Analytics employees in Canada

(Organization: HR and Location: United States) or (Job Function: Analytics and Location: Canada)

Included: Ben and Chen

Everyone in the HR organization, plus Analytics employees in Canada

Organization: HR or (Job Function: Analytics and Location: Canada)

Included: Ana, Ben, and Chen

Employees in the HR organization or employees with an Analytics job function, but only in Canada

(Organization: HR or Job Function: Analytics) and Location: Canada

Included: Ana and Chen

Best practices

  • Start with filters. Use an advanced filter only when you need or between 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.