Filtering data on a report
Purpose of filters
Reports in Targetprocess BI support data filters. Adding a filter is a useful way to see only the data that you want displayed.
Use filters to display specific records in a chart, table, KPI metric, or to export and print only certain records from a chart or query. Filters are compatible with aggregations: it is possible to calculate total count, effort, time spent, or average cycle time only across records that meet the filter criteria. Other items are hidden and do not participate in calculations.
Two kinds of filters exist in reports:
- Personal filters, which are set up by report viewers privately
- Predefined filters, which are set up by report creators in advance, and can be applied by report viewers later
Basic topic: Personal filters
These filters are quite basic, but yet powerful. They can be set up and applied by any report viewer. Changes made to the personal filters not affect any other viewers.
The personal filters can be applied and cancelled quickly. They allow to hide redundant data temporary. It helps to analyze dat without a need to change permanent settings of a report.
To filter report data, click Filters button. Filters tab expands and allows to add, edit, delete filters.
Add the filters with the help of dedicated menus. Remove filters by pressing the cross (X) icon shown on mouse hover.
The personal filters affect only currently visible view in a report. In a multi-view report, switch across views to configure filters per each view separately.
Advanced topic: Predefined filters
These filters release the full power of Targetprocess flexibility. They are set up by report creators in advance and can be applied by a report viewer later.
The predefined filters serve two major purposes:
- Allow report creators to limit data set in a report. As result, only relevant and allowed data becomes visible to report viewers.
- Allow report creators to define 'presets' of filters. It saves time of report viewers as later they just select and apply a proper preset instead of configuring individual filters over and over.
The predefined filters are divided into three categories — source data filters, view filters, and custom quick filters. All the filters are configured in Set up Report mode.
Only report creators (Owners) and Administrators are allowed to change permanent settings of reports.
Source data filters
Source data filters are applied to source data. They affect all views in a
report. To change them in an existing report, press Edit source button.
Some source data filters are modified with visual selectors. Other ones are applied as Advanced
Filters with the help of free-form DSL query language.
To set Source data filters when a new report is created, follow suggestions of the dedicated wizard.
View filters are applied to a currently visible view in a report. To filter report data, click Filters button.
Filters tab expands and allows to add, edit, delete filters. In a multi-view report, switch across views to configure filters per each view separately.
These filters look similar to personal filters. However they are always applied to viewers who have "view" and don't have "edit" access permissions to the particular report. The filters set by report creators cannot be modified and temporary cancelled by such users.
Those having "edit report" access permissions are allowed to temporary cancel the predefined view filters while browsing a report in "view" mode.
Custom quick filters
Custom quick filters affect all views in a report. They are shown in the report header area.
It is possible to filter report records by Targetprocess entities, by dropdown custom fields, by custom text and numeric values.
Filters by Targetprocess entities allow to filter records by related items. Say, you can filter Features by Epic, Agile Release Train, or Program Increment, filter User Stories and Bugs by Feature or Team Iteration, filter Requests by Product, filter Initiatives by Objectives and so on.
Filters by custom fields allow to show or hide record records based on
values in DropDown custom fields. For example, it is possible to create a
report by Features with quick filter by Value Type.
Filters by custom values allow to compose flexible filtering conditions: by entity type names, by workflow states, by people names, and anything else that can be searched in a text or numeric field of a report record. It is possible to build a single Cumulative Flow Diagram for User Stories, or Bugs, or both types together without creating a separate report for each of the type. It is also possible to build a portfolio management report, and quickly switch across deliverables and people groups of your portfolio.
Filtering by collections and tags
The report creator or owner can add the custom quick filters during the report setup process.
Follow the same steps here to add a custom quick filter that allows filtering by a collection. Click the Custom Quick Filters icon and specify the following criteria:
- From the Type drop-down list, select the appropriate entity type.
- Select the checkboxes next to the items you want to display in the drop-down list for report viewers. You can select one or multiple items depending on your requirements.
- From the Apply to the field from the entities used in the report
drop-down list, select the field to which you want the filter to be applied. Fields applicable to
collections will typically include the word collection in their names, though this may vary based on
your account settings.
By default, the filter name is the same as the entity type chosen in the first step, but you can change it for clarity. The default name is Tag, but you can change it for better clarity.
- From the Type drop-down menu, select Tag.
- Check the boxes next to the specific tags that you want to be displayed in the drop-down filter menu for the report viewers. The default name is set to Tag, but you can change it for better clarity.
- A filter cannot be applied to a field that has relationships with more than 200 entities.
- If the report owner attempts to apply a filter to a field exceeding this limit, a warning will appear, and it will not be possible to save the filter.
- Many-to-many filters are not supported in Historical and Cumulative reports. This limitation stems from how Targetprocess stores historical data. Historical and Cumulative reports rely on simple history records to track changes over time. However, these records do not capture changes in linked collections—such as many-to-many relationships (e.g., Bugs, UserStories, or Relations). As a result, no historical data is available to apply many-to-many filters accurately in these reports.
- Click the link in the warning to identify entities exceeding the limit.
- Copy the IDs of these entities to the clipboard.
- Exclude these entities from the filter in DSL mode.
- If a filter is initially created within the specified limits but later exceeds those limits due to other relationships created between entities, the filter will no longer be applicable.
- In this case, the report viewer can contact the report owner, who can fix the filter by excluding entities exceeding the limit.