Issues 'In Progress' for Over 3 Days (Report over time)
This chart configuration helps you track issues over time that remain in a status for more than 3 days, displayed daily. The Performance Trend gadget is used for this report.
Step 1: Add a data source to filter issues with a Status of "In Progress" during the past 30 days. Refer to the image below for more details.
Step 2: Add a conditional metric ‘Time in status’ and choose “In progress” status. Add conditional expression if(P>3,1,0) to count only issues that were in this status for more than 3 days. Switch off friendly format for this report. See sample image below.
Step 3: Set the ‘Display by’ option to ‘Status change date’, which becomes available after selecting the ‘Time in Status’ metric. This configuration allows you to break down the metric by the historical moments when status changes occurred.
Return to the metric selection (Step 2) and enable the ‘Accumulative’ toggle, which becomes available after selecting ‘Status change date’ for the ‘Display by’ field. This setting provides accumulative view of the data.
Step 4: Switch to the area mode, as it is better suited for presenting accumulative data.
Step 5: Stack by ‘Issue type’ field.
Learn more about the Accumulative feature here Accumulative Toggle for 'Time in Status' and 'Time in Assignee' .
Step 1 in detail:
Step 2 in detail: