For some supported report types, Time in Status allows filtering the report output by the calculated report values.
If a report type supports filtering, you will see the Filter button, on the right side of the report output table.
Clicking this button will open a panel the lets you define filters:
- If no statuses are selected in TiS v4.23 - Status panel, all statuses in your Jira will be listed here for filtering. If you select a status that is not present in the report output, the filter will have no effect.
- If one or more statuses are selected, the filter panel will display the list of selected columns (including Consolidated Columns) so you can select one of them.
The filter panel allows you to define multiple filters. You can even define multiple filters for the same column.
Since report values are not necessarily integers, you can enter decimal values as well as integers while defining filters.
For filters, empty columns (any column that the issue did not visit and displayed with a "-" in the report) are considered as zero (0) so if you define a filter like "To Do > 20", you will only see values greater than 20 and will not see empty values. But if you define a filter like "To Do < 20", you will see values smaller than 20 and you will also see empty values. If you want to exclude empty values, you can define another filter for the same column that goes like "To Do > 0" .
When the data is filtered, a small warning icon will be shown next to the Filter button to indicate that the data is filtered. A filter icon will also be shown in the filtered column(s)'s header.
If the report type supports filtering, aggregation reports support this as well. So you can filter the output for List, Average and Sum reports.
The filter selection also affects file exports.
Filtering requires all report data to be calculated so the first filter operation on the selected report dataset might take a little more time to calculate than usual. Subsequent filters on the same data should be quick.