BALANCEtrak > Reports > Filter (Optional)

JUMP TO: Report Settings

KEY TOPICS:

  • Filter by Selected Field
  • Group by Selected Field

NEXT STEP:


Customize Reporting by Selecting Values in Data Fields

Because certain optional settings can be beneficial to reporting output, read the article below — and visit the Reports > Filter module — before entering Select Reports. By selecting values within Requisition fields here, you can globally tailor the reporting output to hone in on particular areas of interest.

Quick Tip: Under Reports, two BALANCEtrak modules control global reporting options — While Report Settings determine what fields to include as columns for a report type, Filter settings narrow and sort results by field values.

A third module, Export Settings, controls the format for exported report files.

Please note that while some fields are typical to all Implementations (e.g., Requisition Number), other fields will be specific to your BALANCEtrak implementation (e.g., [Business unit] Code, Recruiter [code or name]).

Note: Filters by Report Group (e.g., for Job Seeker- or Requisition-specific reports) are available on Select Reports, using [Group Settings].

Filter by Selected Field

The upper Filter menu allows you to: Filter reports on the selected field.

Choose one of provided options, which will include, but are not limited to:

  • Requisition Number
  • [Business unit]) Code

The default setting is: Do not filter on a field.

If a field is chosen, the menu will expand to include existing values available in the field. Select one or more of the provided values. You can also select All or None.

Group by Selected Field

The lower Filter menu provides options to: Group reports on the selected field. This setting will result in a report that is sorted by values in the Requisition field.

The default setting is: Do not group on a field.

Notes: If a Filter is currently set, you may only Group by a level that is higher than the field currently being filtered on. In addition, "Group Reports by" on the Select Reports > [Group Settings] menu will supersede the Filter group setting applied here.


Examples: If a company relies on "Division" as the business unit, filter values may include "Marketing (California)" and "Public Affairs (Washington, DC)". Reporting results will only output for those two Divisions.

Meanwhile, a report, simply grouped by "Division", will display "line-item" results for each named Division in the organization.

Click [Save], which will apply the settings to the next report, viewed or exported via Select Reports. (The Select Reports page will indicate a Filter has been set.)