Time in Status gives you various parameters to shape the data included in the report:
Filter Type
Time in Status report data can be filtered using one of three possible options:
User
User type reports filter issues that are assigned to or were assigned to a selected user. When this option is selected, the option dropdown lists all the users in the system and expects the user to select a user.
Project
Project type reports filter issues that are in a selected JIRA project. When this option is selected, the option dropdown lists all the projects in the system that the current user can access and expects the user to select a project.
Advanced
Advanced type reports filter issues based on a JIRA filter. When this option is selected, the option dropdown lists all the JQL filters in the system that the current user owns or is shared by the current user and expects the user to select a filter.
The filter can return issues from multiple projects so cross project reporting is possible.
Columns By
The Columns By parameter allows the user to select the type of the report. There are 5 different report types:
Status Time
Status Time in the older and the most commonly used of the four report types. Status Time Report lists each issue in rows with statuses as columns and the time that issue spent in that status as column values.
This report helps you identify the bottleneck statuses in the workflow.
Assignee Time
Assignee Time Report lists each issue in rows with user names as columns and the time that issue spent assigned to that user as column values.
This report helps you identify the bottleneck users in the workflow.
Status selection in this report allows you to exclude durations for unselected statuses from the report.
Please note that seleting User as filter type and selecting Assignee as report type is completely unrelated. The former is just for filtering issues and the latter is about the type of calculation made
Group Time
Group Time Report lists each issue in rows with transitions as columns and the total time the issue spent assigned to a member of that group as column values. The report works just like Assignee Time report but consolidate the values under group names.
Group selection allows you to select the groups that will be included in the report. The report output shows one column for each of the selected groups. An extra column is added for assignees that are not member of any of the selected groups. Another extra column is added for the durations issues were Unassigned.
Since a user can be a member of more than one group, there is a possibility of showing duplicate data in the report. In this case, Time in Status warns you about duplicate data by showing a Warning icon on column header.
Transition Count
Transition Count Report lists each issue in rows with transitions as columns and the number of times that transition happened as column values.
This report shows you how many times a transition from one status to another happened so helps you identify most used workflow routes. Especially useful for complex workflows.
Status Count
Status Count Report lists each issue in rows with statuses as columns and the number of times that status was visited as column values.
This report helps you identify re-visits of statuses of particular importance. Expecially useful for identifying reopens, blockages or information requests when these statuses are embedded as optional routes in workflows.
Statuses
The status selection allows the user to select the statuses that will be included in the report and set the display order of statuses.
For Status Time and Status Count reports, the selection directly sets the columns shown in the report. For Transition Count report, transitions that originate from or end up in a selected status is included in the report.
For Assignee Time reports, the report output shows assignee names as columns but the status selection, once again, defines the durations of which statuses to include in the report.
Show Deleted Statuses option allows you to include or exclude statuses in issue histories that are no longer present on system.
When no statuses are selected, TiS acts as if all statuses are selected and includes each status that is present in the current page of the dataset as a column in the report. On the other hand even if only one status is explicitly selected, TiS includes only that status in the report and warns you if any other statuses with data are excluded.
Ordering Statuses
The status selection window also allows the user to set the order of columns shown in the report. If no statuses are selected, Time in Status shows the statuses in the order it encounters them when traversing report data. If statuses are explicitly selected, then the order of selection is respected in the report output. The user can click the up and down arrow icons next to each status name to change the order of statuses.
Fields
Fields selection allows the user to select fields that will be included in the report as columns.
System fields and all built in custom field types are supported.
Custom field types introduced by plugins will be attempted to display as text but might not always display meaningful information.
Ordering Fields
The field selection window also allows the user to set the order of field columns shown in the report. When fields are selected the order of selection is respected in the report output. The user can click the up and down arrow icons next to each field name to change the order of fields.
Groups
Group selection becomes available only for Group Time reports and allows the user to select from all the user groups in the system. The selected user groups are included in the report as columns.
If no groups are selected, the report output should display all time in two extra columns named "Not a member of selected groups" and "Unassigned"
Ordering Groups
The field selection window also allows the user to set the order of field columns shown in the report. When fields are selected the order of selection is respected in the report output. The user can click the up and down arrow icons next to each field name to change the order of fields.
Date Range
The date range window allows the user to selected the beginning and end dates of the report. Date filtering clauses are added to the report filter selected by the user and all issues outside the selected date interval are excluded from the report.
The user can select beginning and end dates for the reports down to minute resolution (since JQL supports minute resolution filtering)
The date filter can be based on Created Date, Resolution Date or Update Date of issues.
Calendar
The calendar selection allows the user to select the calendar which times will be calculated based on. There are 3 possible options:
7/24
This calendar calculates times based on a continous calendar. All durations inside and outside business hours are counted and one day is 24 hours.
Business Hours
This calendar calculates times based on a business calendar that can be set by the JIRA admin from Time in Status settings. Only durations inside business hours are counted. Non-working weekdays and holidays are exluded One day is 24 hours.
Business Days
This calendar is similar to Business Hours in almost every way. Calculates times based on a business calendar. Only durations inside business hours are counted. Non-working weekdays and holidays are excluded.
The difference from Business Hours calendar is: One day is 8 hours long.
Since this option affects only the duration calculations, it is not visible for Transition Count or Status Count reports.
Example:
Let's give an example to clarify the differences between calendars:
By default the business hours calendar is set to work from 09:00 - 17:00 and weekends are non-working days. If an issue was transitioned to "In Progress" on Friday at 16:00 and was transitioned to "Done" on Wednesday of next week at 16:00, different values will show for different calendar types and view formats. (See View Format section below about View Formats)
| Calendar | in Hours View Format | in Days View Format | |
|---|---|---|---|
| 7/24 | 120 | 5 | It is 120 hours or 5 days since nothing is excluded |
Business Hours | 24 | 1 | It is 24 business hours since only business hours are included and it is 1 day since 1 day is calculated as 24 hours |
| Business Days | 24 | 3 | It is 24 business hours since only business hours are included and it is 3 days (3 business days) since 1 day is calculated as 8 hours |
Business Hours and Business Days reports produce the same output for durations shorter than one business day. For longer durations things change: For example a 4h duration is same for both report types but 25h for a 7/24 report is 1d1h for a Business Hours report and 3d1h for a Business Days report. (presuming an 8 hr work day)
ViewFormat
View Format option allows the user to select the format in which durations will be displayed. There are 7 options:
The basic, DD:HH:mm:ss and HH:mm:ss formats shows values in a more user-friendly format. Days, Hours, Minutes and Seconds formats shows values as a single decimal number.
Example:
- Basic: 5 d 18 h 54 m 45 s
- DD:HH:mm:ss: 5:18:54:45
- HH:mm:ss: 138:54:45
- Days: 5.79
- Hours: 138.91
- Minutes: 8334.75
- Seconds:500085