Reporting+: How to Create Filters (with Examples)

Filters define the report criteria and can be used to eliminate the data you do not need in your report.

Advanced filter conditions allow you to limit the amount of data displayed in a report to further refine what data will appear.

Filters can be saved and reused for your given data source. For example, when a filter is created for the timecard data source, that filter can be reused for any future report you create utilizing the timecard data source. Alternatively, saved filters can be modified to include more conditions and/or even cloned.  

Note: Filters created in one data source will not be available in other data sources​ (e.g., filters created for the Timecard data source cannot be used on reports created from the Onboard data source) 

Create a filter

  1. Click Add Filter next to the Filters box.
    R+ add filter
  2. The filter window will appear so you can create your first filter.
  3. First, give the filter a name. A custom filter name is required before the filter can be saved.
    1. Note: You cannot have more than one filter with the same name within a single report, but you can have the same filter name assigned to filters that exist in different reports.
  4. Select a field from the dropdown. These are specific to your data source.
  5. Select a condition to set your filter and refine your results. The following conditions are available and can be used with text, numeric, or dates:
    • Equals (=) Field is equal to a value you specify
    • Does not equal (≠) Field does not equal to a value you specify
    • Is Less than (<) Field is lower than a value you specify
    • Is greater than (>) Field is greater than a value you specify
    • Is less than or equal to (≤) Field is lower than or equal to a value you specify
    • Is greater than or equal to (≥) Field is greater than or equal to a value you specify
    • Contains Field contains a specific value you specify
  6. The "Specify value" field is where you'll specify the type of data that you want in your filter. 
    1. Note: Filters include predictive search which allows the values to populate based on the field you selected. You can begin typing a value in the “Search value” field or select one from the populated list.  
  7. You can choose an operator if you’d like to add more than one clause joined by an AND or OR operator. Having more than one clause in a specific filter will restrict more data results in your report.
    1. Filters with an AND operator restrict report results to data that matches all AND criteria.​ 
    2. Filters with an OR operator open report results to include data that matches any OR criteria.​ 
    3. Note: You can add up to a maximum of 5 clauses in one filter.
      R+ create filter with operators
  8. Click Create and Apply Filter to create the filter.  

Example: Using a filter in Reporting+

In this example, I want to create a report that includes all employees who are from CA and are under 30 years old. 

  1. After I click Create New Filter, I’m going to give this filter a name and begin adding my filter specifications.
  2. I can see that I’m working with the “Onboard data source,” so the fields I can choose from will be limited to onboarding data only.
  3. I’ll choose “Home State” as my field“equals” as my condition, and “CA” as my value. This will let the system know to only display employees whose home state is California.
    R+ home state filter

  4. I also want the report to only show employees who are under the age of 30, so I’ll choose the AND operator and specify the second clause for my filter. 
  5. I’ll choose “Birth Date” as my field, “is greater than” as my condition, and since I know those who are 30 years old were born in 1991, I’ll start typing 1991 to see my options. Using predictive text, the system populated all birthdays from 1991 so I’ll choose the last option, “1991-12-31.” This will let the system know to only display employees who were born after December 31, 1991. 
    R+ age filter
  6. Click Create and Apply Filter to save the filter.
  7. Click Preview to display the results. 
  8. In the screenshot below, you can see that my report includes all employees whose home state is CA and who were born after December 31, 1991.
    R+ filter preview