Tempo logotype

Visualize time in status on Jira dashboards with Custom Charts

From Team '23

Tempo Team

One of the best ways of assessing the productivity of your team and investigating potential blockers is by looking at how long they’re spending on their work. Specifically, how long their Jira issues are spending in a particular status. With Custom Charts for Jira and Confluence, users can visualize time in status on Jira dashboards and Confluence pages, and get an at-a-glance picture of time spent per epic, sprint, assignee, and more.

Questions you can answer with time in status Jira reports

When you make time in status reports with Custom Charts on Jira dashboards or Confluence pages, you can address the following questions.

How long are issues spending in “to do”?

If your issues are spending longer than they should in the “to do” status, this may suggest that there is a problem getting things started. Could there be a capacity problem? Is the team waiting on information? Click on the “to do” segment and you’ll see the issues in question, allowing you to investigate further why some of them are taking a while to start.

How long are issues spending “in progress” or “in review”?

Issues spending ages in the “in progress” status could suggest a blocker that is preventing them from being completed, e.g. absent assignees or dependencies on other teams. If issues are “in review” for a long time, it could indicate that approval processes are not being followed in a timely manner.

How do our sprints compare in time spent?

You can use Custom Charts to look at how time in status compares across your sprints. Was this sprint more complicated? Did that sprint have more issues? Were there resource gaps during that sprint?

How long are different epics taking to complete?

You can also track time in status on epics, letting you see whether some epics are taking too long to complete or get started. What’s causing the delay on this epic versus that epic?

Does this assignee have too much work?

Time in status lets you investigate and compare time spent on work per assignee. If one assignee has a long list of issues still in “to do”, you can ask the question: are they struggling to get started? Have they been away? Equally, if another assignee has loads of items “in progress”, you can ask: are they juggling too much? Do they need help?

Does actual time spent match our estimates?

Many teams will estimate how long their issues are going to take to complete per sprint. By displaying the actual time issues are taking on your charts, you can see whether your estimates were accurate. If not, why not?

2 examples of time in status charts

This bar chart shows the average time spent on issues in the current sprint and reveals that the team does not have any major bottlenecks. However, issues are spending the largest amount of time in the “In Review” status, which is something the manager or Scrum Master ought to keep an eye on.

This bar chart shows the time in status of a software development team working in Kanban. The fact that they work in Kanban, not in sprints, is the reason why things stay so long in “To Do”. This chart reveals that the testing process for new software is actually running pretty smoothly, with tickets moving along quickly. However, they’re tending to stay in “Waiting for Deploy” much longer, which suggests that there could be some bottlenecks in the release process.

How does time in status work in Custom Charts?

Tracking time in status in Custom Charts for Jira and Confluence couldn’t be easier. There are two ways of doing it. Simply select the “Status (Time in Status)” field from the Chart By dropdown, then the Calculate dropdowns will auto-update with the “Sum” of “Time in Status”. (You can also calculate the “Average” of “Time in Status” if you prefer.)

Equally, if you want to take the long way round, select “Status” in the Chart By and then “Sum” and “Time in Status” from the Calculate dropdowns.

You can then use our Simple Search gadget to parse the data down and see how long issues are spending in each status per sprint, assignee, epic etc.

For more details about how to set up and report on time in status on Jira dashboards, take a look at our documentation. This page also explains how to change the time unit from hours to days, weeks, months etc.

Time in status functionality currently works with 1D charts only. However, the functionality will be released for 2D charts soon, allowing you to compare time in status per sprint or assignee on the same chart.

Sign up for a demo

Register

Explore More Content

AI-enabled capacity visualization

Capacity Insights - Open Beta

Deliver visibility into how your team's time and efforts align with business objectives and project ROI - without the manual effort

Learn more

Powered by Structure’s custom hierarchies, visualize your roadmap, project plans, timeline & dependencies within Jira Gantt charts

Go to marketplace

Jira ITSM Solutions with Tempo

ITSM

Build and scale a custom ITSM solution at your own pace with Tempo's modular suite of integrated tools. Enhance Jira's capabilities and take control of your entire IT portfolio.

Learn more

Custom charts and dashboards for Jira

Custom Charts for Jira

See how work is progressing and where blockers are with the most flexible reporting app in Jira.

Learn more

Strategic Portfolio Management

Strategic Portfolio Management

Modern modular PPM solutions that scale with your business. Align your teams with the integrated platform that bridges the gap between strategy and execution.

Learn more

Unified time and team management

Integration: Timesheets and Structure

Combining Tempo Timesheets and Structure PPM provides a unified view of time tracking and project progress, enabling more accurate reporting and effective portfolio management. Simplify workflows, enhance collaboration, and ensure projects stay on time and within budget.

Learn more

No-code BigQuery Jira integration

BigQuery Connector for Jira

Integrate Jira with Google BigQuery to seamlessly export and sync data for advanced analytics and customized reporting

Learn more

Jira Project Cost Tracking

Financial Manager

Project financial management for Jira & Timesheets. Monitor project costs, expenses, revenue, billing & budgets. Track Capex/Opex

Go to marketplace

Agile at Scale Software

Agile at Scale

Adapt to changing business needs, rapidly adjust plans, and reallocate investment.

Learn more

No-code Tableau Jira integration

Tableau Connector for Jira

Effortlessly bridge Jira with Tableau, unlocking unparalleled insights and enhancing decision-making

Learn more

For planning leaders looking to add a big-picture roadmap view to their structured Jira data, this integration is essential. Improve visibility to leadership, reduce reporting admin, and keep your team aligned.

Learn more

No more reporting limitations

Custom Charts for Confluence

Create and share all kinds of highly visual and customizable charts directly on your Confluence pages.

Learn more

Project and program management for Jira

Structure PPM

Visualize all your Jira data & manage portfolios of projects in real-time.

Learn more

Never lose track of a brilliant idea again

Idea Manager for Strategic Roadmaps

Never lose a brilliant idea again. Idea Manager for Strategic Roadmaps has built-in best practices to help.

Learn more

Monitor financial health at every level

Financial Manager for Timesheets

Monitor projects and portfolios to get simple, clear, and real-time views of your costs, budgets, and profits that can be shared throughout your entire organization.

Learn more

Centralize real-time plans in one view

Integration: Structure and Gantt Charts

Gain a more complete project management solution, simplifying project reporting, improving collaboration, and ensuring projects stay on time and within budget.

Learn more

Take control of your projects

Integration: Portfolio Manager and Jira

Portfolio Manager integrates seamlessly with Jira to give you predictive scheduling, real-time scenario modeling, and advanced resource management – ensuring you stay on track, no matter what challenges arise.

Learn more

Time Tracking Software for Jira

Timesheets

Tempo’s intuitive automation and Jira-native design make it the most trusted time tracking tool for enterprise organization.

Learn more
Colleagues interacting around a desk

No-Code Power BI Jira Integration

Power BI Connector for Jira

Effortlessly bridge Jira with your preferred BI tool, unlocking unparalleled insights and enhancing decision-making

Learn more

Real-time collaboration and capacity planning in Jira

Capacity Planner

A powerful team resource management tool designed to optimize capacity planning and project management in Jira

Learn more

Unified time and team management

Integration: Timesheets and Capacity Planner

Seamlessly manage project timelines and resources while accurately tracking time spent on tasks. This integration enhances visibility, improves planning accuracy, and supports data-driven decision-making for better overall project outcomes.

Learn more

Industry-leading project plan and roadmap visualizations with a Gantt chart extension

Gantt Charts for Structure PPM

Visualize project plans and roadmaps with a Gantt chart extension for Jira

Learn more

Align your organization with proactive portfolio management

Portfolio Manager (LiquidPlanner)

Predictive scheduling and the ability to forecast project timelines and spot risks so you can meet deadlines with confidence.

Learn more

Get the data you need to succeed

Time Tracker

Extend your Jira with prebuilt and highly configurable reports for straightforward time tracking.

Learn more

Jira Team & Resource Management

Capacity Planner

#1 Jira Resource Management App: Optimize team allocation, skillset utilization, capacity planning & project management

Go to marketplace

Roadmapping software for teams of all sizes

Strategic Roadmaps (Roadmunk)

The roadmapping tool designed for high-performing teams delivering boardroom-ready strategic roadmaps.

Learn more

Jira Time Tracking

Timesheets by Tempo

#1 Jira Time Tracking & AI Apps: Log Tempo Timesheets for Planning, Project Management & Billing. Plugin Office365, Google & Slack

Go to marketplace

Jira Portfolio Management PPM

Structure by Tempo

Jira Project Portfolio Management (PPM): Visualize data and manage projects within spreadsheet-like tables — in less than a minute

Go to marketplace