Filters can be added as a widget on the Dashboard, which allow you to refine the data shown in each widget using search criteria. Each filter type works by defining a set of fields to filter the widget, along with additional search criteria. The filter setup allows you to choose all relevant fields in the current widget selection for the filter type. For example, a Time-based filter has access to all time fields in the available widgets, such as End Date, Start Date, and Hire Date.
Filters are created on the Filters tab of the Dashboard wizard. When a filter is applied to the dashboard, it removes all records that do not have the value in one of the fields specified in the filter, for all widgets that use the filter fields.
This dashboard has a filter for Contract Type, which limits the data in the widgets to only records that match the selected type. Clicking into the Chart widget opens a table view with the filter applied. |
Each widget has its own setting to control whether filters are applied to its data. To review or adjust the Apply Dashboard Filters setting, edit the widget and go to the Options tab. With this setting enabled, when you select a filter value, the widget refreshes and applies the filter to the data already displayed in the dashboard, much like refining the results of a search.
The fields available for selection in each filter are based on the tables used in the widgets that are currently in the layout. If you do not see a widget field in the filter list, make sure that the widget is included in the Selected widgets list.
The following filter types are supported:
Time filters operate on time-related fields in the tables used in the widgets on the layout. For example, you could create a Time filter that uses the Date Created field to find records that were created this week, this month, or this year.
To create a Time filter:
User filters operate on Person-related fields in the tables used in the widgets on the layout. The filter uses a lookup to the People table, where you select a record that filters the widget fields based on the value contained in the source field.
A User filter might use the Full Name field in the People table as its source field. And for each widget, the filter might use the Created By fields in the Change Requests and Support Cases tables. You could then use the lookup on the filter to select a record from the People table, and the filter would find records in which the value in the Full Name field matches the value in the Created By fields for each widget. If you had added a saved search to find only records where the full name is yours, you could filter the records you see on the People table to include only your own user record. |
To create a User filter:
Team filters operate on Team-related fields in the tables used in the widgets on the layout. The filter uses a lookup to the Teams table and operates on the Team Name field.
A Team filter might use the Assigned Team fields in the Tasks and Service Requests tables for each widget. You could then use the lookup on the filter to select a record from the Teams table, finding only records assigned to the Support team, or any other team, for each widget. |
To create a Team filter:
Linked Source Field filters use linked fields from a source table used in one of the widgets on the dashboard layout, which are used to filter the related values in the widget fields. The filter uses a lookup on the linked source table, where you select a record containing the linked source field.
A Linked Source Field filter might use the Projects table as the linked source table and the Project Name field as the linked source field, which are linked to from the Tasks table. For each widget, the filter might use the Project Name linked field in the Tasks table. You could then use the lookup on the filter to select a record from the Projects table, and the filter would find records in which the linked Project Name source field in the Projects table matches the linked Project Name field in the Tasks table. |
To create a Linked Field filter:
Each filter can use the default style or a custom one. The styles affect the area outside of the selection look-up or drop-down list.
Related articles |