Report Builder filter guide

Permissions_and_Product_Tier.png

Filters enable you to create rules for the data you wish to see returned in your report. Report Builder uses filters that can be both customized and layered, allowing you to specify conditions for the type of data you want to view in your report. 

In addition to allowing you to filter for specific data, Report Builder also includes not operators, allowing you to exclude specific results from your report. 

In this article, we will cover: 

To begin, create a new custom report and click Filters

1.png

 

Report Builder Filters Overview

The type of custom report you create will dictate how the data can be filtered. For example, a custom report based on a Job Summary template will provide you different filtering options than a custom Candidate report. Regardless of what type of custom report you are building, the process to create a filter will be the same.

For each filter you apply to a custom report, you will select the following: 

  • Property: The field or metric by which you want to filter the report data
  • Operator: The relationship between the property and the value
  • Value: The criteria applied to the property

From the Custom Report Preview page, select a property option from the available list.

Note: The operator and value options available to choose from are dependent on the property, so these dropdowns cannot be edited until you have selected an option from the Property dropdown. See the Available Operators and Definitions section of this article for more details about operators. 

3.png

Once you have set the Property dropdown to define the metric by which you want to filter, select values from the Operator and Value dropdown menus. 

5.png

Example: When creating a custom report based on the Jobs Summary template, you might want to see data only for jobs in the Engineering department. To create a filter for this, make the following selections in the appropriate dropdowns: 

Department 
(property) is equal to (operator) Engineering (value)

mceclip0.png

To add more values to an existing filter, click the Values dropdown and select from the available options. Click each additional option you wish to include in the filter. If more than one option is added to the Value field, each option will be treated as an OR. For example, in the image below, the report data will be filtered for candidates who have a status of either hired OR active. 

6.png

Custom reports allow you to layer multiple filters to drill down into your data. To add another filter, click + Add Filter and select options for the Property, Operator, and Value dropdowns. Repeat this step to add as many filters as you wish.

7.png

Example: Continuing with the example above, you could narrow your custom Jobs Summary report further by applying a second filter for Office (property) is not equal to (operator) Palo Alto
(value). Now you have created a report that returns details for Engineering jobs which are in any office except Palo Alto. 
mceclip1.png

 

Available Operators

Report Builder uses the operators listed below. Operators are dependent on the selected property and the property's associated values; not all operator options will be available for every filter. For example, date-based operators will be available only if you select a property value related to dates, such as Application Date

After

Date-based operator; returns data where property option occurred after the date selected for value.

Before

Date-based operator; returns data where property option occurred before the date selected for value.

Between

Date-based operator; returns data where property option occurred between two exact dates selected for value. Does not allow user to select relative dates (e.g. Previous Year) or specific number of days (e.g. Last 90 Days). 

Contains

Returns data where property option includes specified string of characters (entered as value). Example: The filter Job Name (property) contains (operator) Program Manager (value) will return jobs with a title that includes "Program Manager." 

Does not contain

Returns data where property option does not include specified string of characters (entered as value).

Greater than

Numeric-based operator; returns data where property option is larger than selected numeric value. Example: The filter Days Open (Job) (property) greater than (operator) 45 (value) will return jobs that have been open longer than 45 days.

Is defined

Returns data where property option has been provided, but does not consider what information was entered for the property option. Does not allow user to enter a value. Example: The filter Department (property) is defined will return data for all jobs with a listed department.

Is equal to

Returns data where property option is an exact match for selected value. 

Is not defined

Returns data where property option has not been provided. Does not allow user to enter a value. Example: The filter Department (property) is not defined will return jobs not associated with any department.

Is not equal to

Returns data where property option is anything except selected value.

Less than

Numeric-based operator; returns data where property option is smaller than selected numeric value. Example: The filter Days Open (Job) (property) less than (operator) 45 (value) will return jobs that have been open for less than 45 days.

On or after

Date-based operator; returns data where property option occurs on or after a specified date (entered as value).

On or before

Date-based operator; returns data where property option occurs on or before a specified date (entered as value).

Within

Date-based operator; returns data where property option occurred within either a relative date range (e.g. Previous Year) or within a specific number of days (e.g. Last 90 Days). Does not allow user to specify exact dates.

 

Additional Resources