WIP Aging Chart Gadget

On this page

https://youtu.be/ZuoV7AfjyYw

Overview

Depending on how you configure it, this gadget displays the "work-in-progress" (WIP) issues from a filter or an agile board in a scatter plot chart by their time (age) in their status or board column. Optionally, the chart can display percentiles or the average line. Also, a custom threshold line can be added for easily identifying the issues that have an age (time in status or time in column) higher than expected.

You can use this gadget to easily identify the issues that stay longer than expected in a specific workflow status or board column. Hovering the mouse pointer over an issue in the chart will display a tooltip with the issue details, like the issue summary or age. If configured to display the columns of an agile board, the gadget also displays the WIP limits of the boards and highlights them accordingly when these limits are exceeded.

image-20240129-110124.png

The age calculation method is configurable. The gadget can display a Data tab with more details about every issue displayed in the chart.

See the settings description below for how to configure the gadget.

Configuration

The settings of this gadget are divided in 2 tabs:

  • Data tab - contains the required settings of the gadget, such as title or data source

  • More Settings tab - contains the optional settings, such as card colors

Data tab

On this tab you can configure the required settings of the gadget.

image-20240129-105153.png

Setting

Description

Setting

Description

Gadget Title

Choose what to display in the title bar of the gadget.

Data Source

Select the type of Data Source used by the gadget:

  • The agile Board of your team.

  • A Saved filter containing the issues that you want to track in the chart. Make sure that the specified filter is shared with the users who will also visualize this gadget. Check Include the sub-tasks if you want the sub-tasks from the selected board, filter or JQL to be included in the calculation. Also, check Include the issues from the "To Do" category if you want the "To Do" issues to be displayed along with the "In Progress" issues.

  • A JQL query that returns the issues you want to be processed by the gadget.

Display chart by

It indicates what the chart displays on its horizontal axis and how the issues are grouped in the chart.
The statuses of the issues makes the horizontal axis display the statuses of the issues. If Data has a Board selected, the horizontal axis of the chart displays the workflow statuses mapped on the "in-progress" columns of the selected board. If Data has a Filter selected, the horizontal axis of the chart displays the "in-progress" category statuses of the issues from the selected filter.
The columns of the selected board makes the chart display on its horizontal axis the "in-progress" columns of the selected board along with their issues.

Age calculation method

Specify how the age is calculated by choosing one of these options:
Sum-up the time of all the occurrences in current status or board column - the age is the total time spent in its current status (if the chart is displayed by The statuses of the issues) or the total time spent in its current board column (if the chart is displayed by The columns of the selected board). The previous occurrences are counted.
Sum-up the time of all the occurrences in the category of its current status or board column - the age is the total time spent in the category (To Do, In progress or Done) of its current status (if the chart is displayed by The statuses of the issues) or of its current board column (if the chart is displayed by The columns of the selected board). The previous occurrences in the status/board columns from the same category as the category of its current status/board column are all counted.
The time since the first occurrence in the category of its current status or board column - the age is the total time since the moment when the issue reached the category (To Do, In progress or Done) of its current status (if the chart is displayed by The statuses of the issues) or of its current board column (if the chart is displayed by The columns of the selected board). The time since the issue creation - the age is the total time from when the issue was created to now.

More Settings tab

On this tab you can configure the optional settings of the gadget.

Setting

Description

Setting

Description

Calculate age in

Specify in what time unit measure the age of the issues will be displayed.

Don't count weekends

Check this option if you want to exclude the weekends (Saturdays and Sundays) from the age calculation.

Display average line

Check this option if you want the chart to display a line with the average age for all the issues displayed in the chart.

Display threshold line

Check this option if you want the chart to display a line representing a threshold. The issues that have an age higher than the specified Threshold value will be colored in red.

Display percentile lines

Check this option and enter the values (percents) corresponding to the percentiles to be displayed. A percentile is a value from the data set that splits the data into two pieces: the lower piece contains the percent of the data, and the upper piece contains the rest of the data. For example, the 75% percentile will be displayed as a horizontal line with 75% of the issues under it and the rest of the issues (25%) over it.

Use logarithmic scale for the vertical axis

Check this option if you want the chart to display a logarithmic scale instead of a linear scale for the Y axis.

Show legend

Check this option if you want the chart legend to be displayed.

Show data table

Check this option if you want a data table to be displayed along with the chart. The Data tab displays the issues grouped by status or board column along with their time spent (age) in their current status or board column for all their occurrences in that status or column.

Colors tab

Setting

Description

Setting

Description

Automatically assign colors

Check this if you want the chart to automatically assign colors for the series.

Custom colors

Select any custom color you want the series to be displayed on by either entering the color's hexadecimal code or picking a color.

You can also use the Copy and Import buttons to copy and import the color configuration to gadgets of the same type.

 

Related blog articles

The following blog articles provide more information on how to use this gadget.