Time in Status Gadget

On this page

https://www.youtube.com/watch?v=dconSrll6NA

Overview

This gadget indicates how long issues stayed in each workflow status, status category, or board column. You can choose to show total time or average time, or group the data by different criteria, such as assignee, project, or priority. The displayed result can be in the form of pie chart, bar chart or line chart as per your choice.

This gadget is especially useful for identifying workflow bottlenecks, understanding team performance, and ensuring projects stay on schedule.

image-20240726-050023.png
Time in Status as Stacked Column Chart

 

image-20240726-050051.png
Time in Status as Pie Chart

 

 

 

 

The gadget can display a Data tab with detailed information about each issue and the time in the statuses reached during their life-cycle, which you can easily export in CSV format.

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

Data tab

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

 

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 that returns the issues you want to be processed by the gadget. Make sure that the specified filter is shared with the users who will also visualize this gadget.

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

Count also the sub-tasks and their estimate

Check this option if you want the gadget to consider the sub-tasks from the selected board, filter or the specified JQL.

What to measure

Choose what you want the gadget to measure. You can chose between:

  • Time in status - By selecting this option the gadget will calculate the time in every workflow status that issues reached during their life-cycle.

  • Time in status category - By selecting this option the gadget will calculate the time the issues stayed in every status category: To Do, In progress or Done.

  • Time in columns of the selected board - By selecting this option the gadget will calculate the time the issues stayed in every column of the selected board. This option can only be used with a Data source of type Board.

Calculation method

Indicates how calculate the time. You can choose between:

  • Total time - By selecting this option the gadget will calculate and display the time in status, category or board column by summing-up the time spent on all the issues

  • Average time - By selecting this option the gadget will calculate and display the time in status, category or board column as the average duration by dividing the total duration to the number of issues

Group data by

Optionally, you can choose to group the data by an issue field, such as Assignee, Issue Type, or Priority, of your choice.

Chart type

The type of the chart to be displayed by the gadget.

If Group data by is set to None, you can choose from Column chart, Bar chart, Pie chart, or Stacked column chart. Otherwise, you can choose either Stacked column or Stacked bar.

More Settings tab

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

 

Setting

Description

Setting

Description

Statuses to process

Specify what statuses to be processed. You can choose one of the following options:

  • Only statuses in these categories - The default option. If selected, the gadget will only process statuses from the selected status categories. By default, only the To Do and In Progress categories are selected; the Done category is intentionally excluded because issues in this status category will most likely remain in their current done-category status and the time in that status will continually increase, thus not being relevant for the analysis.

  • All statuses except these - By selecting this option the gadget will process all statuses reached by the issues except those specified. This option is useful if you want to exclude certain statuses from the analysis.

  • Only these statuses - By selecting this option the gadget will process only the specified statuses.

  • All the statuses - By selecting this option the gadget will process all all statuses reached by the issues.

Calculate in

Specify in what time unit measure the results will be displayed.

Don't count weekends

Check this option if you want to exclude the weekends (Saturdays and Sundays) when calculating the time in status.

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 along with time in every status, status category or column of board depending on what you selected at What to measure on Data tab.