Great Gadgets for Jira & Confluence
Breadcrumbs

WIP Aging Chart Gadget


Overview

Depending on how you configure it, this gadget displays the "work-in-progress" (WIP) work items 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 work items that have an age (time in status or time in column) higher than expected.

You can use this gadget to easily identify the work items that stay longer than expected in a specific workflow status or board column. Hovering the mouse pointer over an work item in the chart will display a tooltip with the work item details, like the work item 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.

WIP-aging-chart-gadget.png

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

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

Configuration

The settings of this gadget are divided in multiple tabs:

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

  • More Settings tab - contains the optional settings

  • Colors tab - lets you customize the color of the lines displayed in the chart

Data tab

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

WIP aging chart gadget configuration in Jira - data tab.png

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 work items 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 work items from the "To Do" category if you want the "To Do" work items to be displayed along with the "In Progress" work items.

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

Display chart by

It indicates what the chart displays on its horizontal axis and how the work items are grouped in the chart.
The statuses of the work items makes the horizontal axis display the statuses of the work items. 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 work items 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 work items.

Age calculation method

Specify how the age is calculated by choosing one of these options:

  • Time since last entry in current status or board column - the age is the time since the last entry in its current status (if the chart is displayed by The statuses of the work items) or the time since the last entry the current board column (if the chart is displayed by The columns of the selected board). The previous occurrences are not counted.

  • Sum-up the duration 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 work items) 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 duration 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 work items) 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 work item reached the category (To Do, In progress or Done) of its current status (if the chart is displayed by The statuses of the work items) or of its current board column (if the chart is displayed by The columns of the selected board).

  • The time since the work item creation - the age is the total time from when the work item was created to now.

More Settings tab

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

WIP aging chart gadget configuration in Jira - more settings tab.png

Setting

Description

Calculate age in

Specify in what time unit measure the age of the work items 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 work items displayed in the chart.

Display threshold line

Check this option if you want the chart to display a line representing a threshold. The work items 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 work items under it and the rest of the work items (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 work items 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.

WIP-Aging-chart---data-table.png

Open data tab first

Check this option if you want the gadget to open on the Data tab first (instead of Chart tab as default). Note that the tab order will remain unchanged (Chart, then Data); only the initial view will switch to the Data tab.

Display statuses in this custom order

Choose the order in which you want the statuses to appear. This lets you control how they are displayed in the gadget.

Tilted labels for x-axis

Check this option to avoid overlapping labels on the x-axis.

Colors tab

On this tab you can customize the color of the lines displayed in the chart.

WIP aging chart gadget configuration in Jira - colors tab.png

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.


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