Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
typeflat
separatorpipe
Excerpt
hiddentrue
time_in_status_thumbnail.png

TIME IN STATUS

Identify bottlenecks by reporting on status time (how long statuses were active) per status, date, issue or assignee

Overview

Identify bottlenecks and insights into how much time issues spend in different statuses: Analyze status time per issue, per status, per assignee or over a specific date range.

  • Bottleneck Identification: Easily spot bottlenecks in your projects by analyzing how long statuses remain active in your Jira issues.

  • Performance Evaluation: Evaluate team performance by seeing who's effectively moving issues through various statuses.

  • Issue Analysis: Dive deep into individual issues to understand how much time each issue spent in different statuses.

  • Cross-Project Reports: Generate comprehensive reports across multiple projects to track time spent on each status, assignee, etc.

preview_time_in_status_by_date.png
preview_time_in_status_per_status.png
preview_time_in_status_per_issue.png

Select statuses

Select which statuses to include in the report, you can include individually a status each time, or all the statuses in a specific status category by clicking in the TO DO, IN PROGRESS or DONE sections, see the following interactive demo:

https://demo.arcade.software/JpOWTaoWEX495XpDUGQy?embed&show_copy_link=true

Report type

Report by status

Analyze time distribution across statuses to identify workflow bottlenecks and optimize efficiency.

Select any of the two view types: Pie chart or 1D Pivot Table

time_in_status_report_by_status_pie.png
time_in_status_report_by_status.png

Report by assignee

Evaluate how different team members are progressing through tasks and how much time they spend in each status.

Select any of the three view types: 2D Pivot Table, Stacked Bar Chart, Grouped Bar Chart

report_by_assignee_stacked.png
report_by_assignee_2d_pivot_table.png
report_by_assignee_grouped.png

Report by issue

Dive deep into individual issues to understand their status progression through its lifecycle and identify areas for improvement.

MISSING IMAGE HERE

Report by date
Status
colourGreen
titlesoon

Track how the time in status of issues evolves over time, plotted against a timeline.

preview_time_in_status_by_date.png

Configuration

History to retrieve

To enhance the precision of your report, you can trim the history of your issues. Thus, you have the option to filter out historical data within a specified timeframe. This involves choosing both a "before" and "after" date to exclude data, ensuring that the time in status of relevant issues during that period are disregarded in calculations.

Time_in_status_trim_dates.png

Format

You can choose to display the time in three different formats: Hours, Days or Time centric (w for weeks, d for days, h for hours m for minutes).

Measure

You can decide how to calculate the time in each status:

  • Mean: The average of all the time spent in each status.

  • Sum: The total sum of all the time spent in each status.

  • Max: The maximum time spent in a status.

  • Min: The minimum time spent in a status.

Customizations

Custom colors

The color picker allows the selection of color of each specific segment or value either by hexadecimal code, RGB, or our pre-defined 24-color palette (selected based on the right contrasts and tones).

color_picker.png

Hide segments

Clicking on the 👁 eye icon, the corresponding segment is hidden (or shown) in the chart.

Reorder segments

Just drag and drop any segment or value from the six dots on the left side of the segments and move it upwards or downwards to the correct place, and the chart will be updated accordingly.


Configuration

Name your gadget meaningfully, so everyone knows at a glance what it is about and when to use it. Fill out the rest of the fields as applicable, namely:

  • The datasource, where the source Jira instance is installed.

  • Use a filter or a custom JQL (Jira Query Language) query to define the dataset for analysis. This query will determine the data used to calculate the work time that was required in the different statuses.

  • The statuses to be included in the report (see this section).

  • The history of the issues to be retrieved, so the report is more precise.

  • The reporting type, whether you want to report by statuses, issues or assignees.

  • The view type, you can change the view of reports to better communicate the result.

  • The format of the displayed time: Hours, days or time centric.

  • The measure used to calculate the time in status: Mean, sum, max or min.

  • Finally, indicate if you want to use the current settings for all the compatible gadgets in the dashboard. This option eases the pain of configuring one by one the rest of the gadgets with the same default configuration

Integrations

  • (blue star)

Expand
titleJira Software
Filter by label (Content by label)
showLabelsfalse
maxCheckboxfalse
showSpacefalse
reversefalse
cqllabel = "jira" and space = currentSpace ( )
  • (blue star)

Expand
titleJira Service Management
Filter by label (Content by label)
showLabelsfalse
showSpacefalse
cqllabel = "jira_service_management" and space = currentSpace ( )

We are working on our growing catalog of Dashboard Gadgets: KPIs and Metrics and Dashboard Integrations: Supported Products, but contact us you want us to expedite a specific one, visit our Help Center.

Dashboards

This gadget is not included in any pre-defined dashboard, check other orphan gadgets:

Expand
titleOrphan gadgets
Filter by label (Content by label)
showLabelsfalse
showSpacefalse
cqllabel = "orphan_gadget" and space = currentSpace ( )

See also

Filter by label (Content by label)
showLabelsfalse
maxCheckboxfalse
showSpacefalse
reversefalse
cqllabel = "time" and space = currentSpace ( )