Report Generation in Time Between Statuses

1. Filter data

Select project to filter issues.

Open

2. Date Ranges

Use the Date ranges functionality to customize report timeframes.

Open

When clicking the first bar, you can select three types of date range:

• Created - dates when the issues were created;

• Updated - when they were updated;

• Resolved - dates when the tasks were finished.

Then, you can choose the period based on which you want to get the report.

It can be Date ranges (yesterday, last week, this month, etc.) or you can select the custom time duration From date - To date.       

 3. Issue Type Filtering

This feature allows filtering all issues by their type: 

• Story,

• Epic,

• Task,

• Bug,

• Subtask.

To get a report based on a necessary issue type, put a tick at the type you need.

To get a report based on all issue types, put a tick at all issue types you have in your workflow.

4. Choose a Time format

The Format option lets you select the time format of status duration:

• DHM (Days, Hours, Minutes)

• HM (Hours, Minutes)

• h:m (hours:minutes)

• M (Minutes)

• Decimal Hours

• Decimal Days

• Decimal Weeks

• Business DHM, 

• Business Decimal Days, 

• Business Decimal Weeks.

*Please note, to export data for analysis, choose one of the Decimal time formats. It will enable you to perform calculations on the exported data and build charts.

4. Report

The Time between statuses report contains columns with information about issues (Type, Key, Summary - are constant; Assignee, Status, Time between statuses, etc. - may change at "Columns" menu) and column with time between statuses of every issue (which you have configured at the configuration).

Colors for warning:

Warning time limit - yellow

Critical time limit - red

5. Export

Export Time Between Statuses data as XLSX or CSV files and analyze it using Excel or Google Spreadsheets.

*Please note, to extract data for analysis, choose one of the Decimal time formats. It will enable you to perform calculations on the exported data and build charts.