Monthly Average Time in Columns (Jira, Trello)
Optimizing development workflows is now a priority for companies of all size and trade. Identifying bottlenecks, calibrating sprints better and being able to precisely measure the time and efforts spent in each stage of the development process are keys to delivering better quality software in record times, whilst maintaining cost control. By tracking the time an issue spends in a status (or column), you gain crucial insights into your workflow. This practice enables you to enhance efficiency, accountability, and overall performance, making it an essential metric for driving continuous improvement and delivering high-quality results.
Optimize Your Development Workflow, Detect and Fix Bottlenecks
with the
Monthly Average Time in Columns (Jira, Trello)
Optimizing development workflows is now a priority for companies of all size and trade. Identifying bottlenecks, calibrating sprints better and being able to precisely measure the time and efforts spent in each stage of the development process are keys to delivering better quality software in record times, whilst maintaining cost control. By tracking the time an issue spends in a status (or column), you gain crucial insights into your workflow. This practice enables you to enhance efficiency, accountability, and overall performance, making it an essential metric for driving continuous improvement and delivering high-quality results.
From startups to large enterprises, Keypup serves all the unique complexities related to project size, structure and teams, including:
“Keypup is a highly useful and practical platform, boasting user-friendly features and lightning-fast report generation.
The service provided by customer support was excellent, showcasing their dedication to customer satisfaction. We are delighted to be part of the Keypup community.”
“Keypup has been instrumental in helping us gain a better perspective on our engineering activities and identifying bottlenecks. Its ease of use combined with its comprehensive features made a difference for us”
“Great product with great support!
‍
Keypup is extremely flexible in its reporting. Once you get your raw data connected, there is almost nothing it can't do. There is a wealth of tables, charts and other reports available. As Director of a software development team, I use Keypup to report on our work efficiencies to senior managment. Keypup makes this task very simple to produce each week.”
What is the Monthly Average Time in Column insight?
Companies use this insight to analyze their development stages and detect bottlenecks. The recommendation is to keep each stage short to maintain an agile delivery flow. Tracking the time Jira or Trello issues spent in a given status is critical for optimizing development processes and ensuring efficient workflow management.
This metric is calculated by looking at the time taken by each stage of development across the issue lifecycle, broken down per month.
The Time per Column is broken down into 3 stages:
- Pickup time is the total duration spent in the initial status (“To Do” or “Selected for Development” by default) before the development starts
- Coding time is the total duration spent in the development status (“In Progress” by default)Â
- Testing time is the total duration spent in the test status ( "Staging", "UAT" or "QA" by default)Â
Statuses names can be changed to match your specific Jira or Trello definitions.
Key Benefits of the Monthly Average Time in Column for Jira and Trello
- Identify Bottlenecks: Pinpoint stages in your workflow where delays frequently occur. This insight helps in addressing and mitigating bottlenecks, improving overall process efficiency.
- Improve Estimations: Enables better estimation of task durations, leading to more accurate project timelines and resource allocation, enhancing your team's planning and forecasting capabilities.
- Measure Performance: Evaluating team performance and productivity. By setting benchmarks and analyzing trends over time, you can identify high-performing areas and those requiring improvement, ultimately boosting team efficiency and output.
- Ensure Transparency: Fosters transparency within the team and with stakeholders by providing a clear picture of progress and potential delays, facilitating better communication and collaboration
- Optimize Workflows: Refine and streamline workflows based on data-driven decisions to reassign tasks, adjust priorities, and implement process improvements, leading to more efficient operations.
How to Improve on this Metric?
Pickup Time is High
- Locate bottlenecks in engineers’ plannings
- Use the Value Stream Management dashboard to understand your engineering habits and patterns and optimize your resources allocation, and added-value
- Use the Sprint overview dashboard to assess your engineering team’s planning and activity.
- Avoid issue “hoarding”: Only add issues to the development tasks that you know your team can deliver.
Coding Time is High
- Reduce the size of issues/user stories to streamline the development tasks.Â
- Locate bottlenecks in engineers’ plannings
- Use the Value Stream Management dashboard to understand your engineering habits and patterns and optimize your resources allocation, and added-value
- Use the Sprint overview dashboard to assess your engineering team’s planning and activity.
- Ensure the scope of tasks is clear as missing or vague specifications often lead to back-and-forths and longer development times.
Testing Time is High
- Reduce the size of issues to streamline the reviews. Bigger items are less likely to be picked up for testing and are more difficult to review.
- Give engineers some dedicated time to perform their review on a daily or weekly basis.
- Empower senior engineers to make junior reviewers grow into making relevant and rigorous reviews (which eventually leads to fewer reviews).