Remaining Time to Due Date vs Overdue Time
This report clearly distinguishes between overdue issues and their overdue times (shown in the first four rows of our sample report), and due or upcoming tasks by displaying the remaining time to their due dates (in rows 5 to 20). This makes it easier to prioritize work and take timely action.
The gadget used for this report is Scatter and Bubble Charts gadget in Pivot table view.
Step 1: In the Data Source, disable the Date Range, select the project you want to analyze, and add the JQL query: duedate is not EMPTY AND resolution is EMPTY, to filter unresolved issues that have an assigned due date.
Step 2: Select the ‘Remaining time to due date’ metric and choose Resolved for “actual date” and Due date for “due date”.
Step 3: Configure “Display by” with the “Assignee” field.
Step 4: Configure “Group by” with the “Overdue state” field, set up from Resolved to Due Date.
Step 5: Configure the Bubble size with the “Overdue time from date” field, configured from Resolved to Due date.
Step 6: Under More Settings switch from Chart to Pivot table default view and activate Expanded view.
You can further customize your chart by displaying the result in Minutes, Hours, or Days. Additionally, you have the option to Round the result or toggle the Friendly format to view an easy to read and grasp form of dates and numbers. These flexible settings allow you to present the data in a way that best suits your reporting and analysis needs.