--- title: "Time in Status" canonical: "https://support.appfire.com/space/RDD/866058316/Time%20in%20Status" format: markdown --- > Macro (aura-html) > Macro (excerpt) > > ![Dashboard Hub Time in Status gadget thumbnail](media://c6c810e5-9503-4a73-b149-91695b25c101) > > [TIME IN STATUS](https://appfire.atlassian.net/wiki/spaces/RDD/pages/866058316) > > [Identify bottlenecks by reporting on status time (how long statuses were active) per status, date, issue, or assignee](https://appfire.atlassian.net/wiki/spaces/RDD/pages/866058316) ## Overview Use the Time in Status gadget to identify bottlenecks and gain insights into the 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 has spent in different statuses. - **Cross-Project Reports**: Generate comprehensive reports across multiple projects to track time spent on each status, assignee, etc. --- ## Select statuses You can select which statuses to include in the report. You can view individual statuses or all statuses in a specific category by selecting TO DO, IN PROGRESS, or DONE sections. Follow the following interactive demo to learn how. ### Status groups You can create your own status groups and merge multiple statuses into a single category, simplifying and enhancing your reporting capabilities. > ℹ️ Some aggregations might not make sense if you combine individual statuses with groups that include some of those included statuses, for example, a group called Already done containing Failed and Completed used together with the status Failed. ![Dashboard Hub status groups time in status chart](media://a5606c17-ca7d-4a6d-8f23-ed3b58072cb2) ## Report type ### Report by status Analyze time distribution across statuses to identify workflow bottlenecks and optimize efficiency. Select either of the two view types: Pie chart or 1D Pivot Table ### 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 issue Dive deep into individual issues to understand their status progression through their lifecycle and identify areas for improvement. ### Report by date Track how long issues have stayed in each status for a specific period of time (day, week, month, quarter, year). This allows teams to track and analyze status durations across the whole portfolio, seeing its evolution over time, plotted against a timeline. For example, last week: - An issue TIS-1 was 2 hours in the **To Do** status, 3 hours in the **In Progress** status, - and TIS-2 was 5 hours in the **To Do** status and 8 hours in the **In Progress** status. Then, the 'Report by date' report shows for **Last Week** 7 hours in the **To Do** status and 11 hours in the **In Progress** status. Select any of the four **view types**: Multi Line chart, Stacked Area chart, Grouped Bar chart, Stacked Bar chart. Each segment (e.g., each line in the multi-line) represents one status. ![Dashboard Hub Time in Status gadget example](media://57c87789-c0e9-4260-87d0-c46d471aeee0) ### Switch between Chart and Table view A switch in the gadget header lets you choose to display the chart or a table with the underlying data. This option is available in the gadget’s main view when the dashboard is not in Edit mode. ![Dashboard Hub Time in Status configuration row](media://5de753d7-b347-4361-ad73-26ee618b98fb) --- ## Configuration ### Issue history To improve the precision of your report, you can trim the history of your issues to filter out historical data within a specified timeframe. Select a before and after date to exclude data, ensuring that the time in status of relevant issues during that period is excluded from calculations. ![Dashboard Hub trim dates setting](media://58b8f662-8a96-48f0-a4aa-928e4858d219) ### Format You can 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. > ℹ️ **Time in Status** is cumulative per status, and the total time is averaged across statuses. > ℹ️ > ℹ️ **Lead time** counts the time from the moment a piece of work is in a* To Do* status until the moment that piece of work reaches a *Done *status. However, **Time in Status** doesn’t stop counting when that work reaches the *Done *status. > ℹ️ > ℹ️ *Unassigned* is included as *None* in reports. ### Show statistics You can select which statistics to display in the report. All available statistics are shown by default. ![Available statistics for the Time in Status gadget.](media://8cb71149-9836-4f7a-b017-e0898a9827b2) ## Customizations ### Custom colors The color picker allows you to select the 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). ![Dashboard Hub chart color picker](media://abe06fd9-f0c5-4584-a7bd-0f44bd2e5a8f) ### Hide segments Click the **Eye** icon to show or hide the corresponding segment in the chart. ### Reorder segments You can drag any segment or value from the six dots on the left side of the segments and move it up or down to the correct place; the chart will be updated accordingly. --- ## Dashboards This gadget is not included in any pre-defined dashboard.