Display the data you need with filters on Table Reports
Table Reports can display all data between related Workflows; however, there are situations where you may want to display targeted information. Filters allow you to preset subsets of data on Table Reports for display. If you need guidance on how you can create Table Reports, you can refer to Create Table Reports.
Working With Filters
You can add filters to your Table Report by clicking Edit Report at the top right of the Table Report in question. In the modal that pops up, scroll to the "Filters" section and click + Add Filter.
You can then select the Field you want to filter by. You can even filter Records based on Fields that are not included in the Table Report.
Filtering Options
The types of filters you can apply will vary depending upon the type of Field you are filtering on and whether it is a text-based Field or a numeric Field. The types of filters available for different Fields are listed in the charts below.
Filters for Text-based Fields
If you filter on multiple values in the same field, the system will apply OR logic to determine what should be displayed. If you filter on different fields, the system will apply AND logic and display records that relate to all of the filters.
Filters for Numeric Fields
Relative Date Filters
Due Date and Custom Date Fields can be used to create filters that are relative to the Current Date. When you add a filter for a Due Date or Custom Date Field, select the Relative filter option, then select an operator from EQUALS, NOT EQUALS, GREATER THAN, LESS THAN, and DATE RANGE. Note that the Current Date can only be selected with the operators EQUALS, NOT EQUALS, GREATER THAN, and LESS THAN. You must select DATE RANGE in order to choose from a given set of time interval options (with no option to select the Current Date).
There are several time intervals before and after the Current Date that are supported by the relative date filter with the DATE RANGE operator, including:
LAST 7 DAYS
LAST 30 DAYS
LAST 3 MONTHS
LAST 6 MONTHS
LAST 9 MONTHS
LAST 1 YEAR
NEXT 7 DAYS
NEXT 30 DAYS
NEXT 3 MONTHS
NEXT 6 MONTHS
NEXT 9 MONTHS
NEXT 1 YEAR
Example Use Case
In the context of an Enterprise Risk Management Application, you might want to only view Risks that have an Inherent Risk Score that categorizes the Risk as "High." Such a filter will have the following configuration.
Note that, as in the case above, if Calculation Field has a label associated with it, the Field can be filtered based on either the value of the Field or the label.
Once a filter is added, you can click on the gear icon and toggle the filter to Flexible. This will allow your end users disable the filter when viewing a Table Report if they wish to do so.
Filter by User Activation Status
User Fields and the Current Assignee can be filtered by user activation status using the IS and IS NOT operators. This is helpful for administrative organization—for example, Power Users can surface every Record currently assigned to a Deactivated User so that ownership can be reassigned to an Active User.
To set up an activation status filter, click + Add A Filter on your Table Report and select a User-type Field (such as a custom User Field or Current Assignee). Choose IS or IS NOT as the operator, then select the activation status you want to filter on:
- Active — Users who can currently access Risk Cloud
- Deactivated — Users whose accounts have been deactivated
- Locked — Users whose accounts have been locked due to too many incorrect password entries
The IS and IS NOT operators are available on all User-type Fields, including the Current Assignee and any custom User Field configured in your Workflows.