You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Hello Trello Community,
If you’ve ever been managing a project of any kind, you know how important it is to have a good idea of when you can expect the work to be done. Today we’ll learn about a chart that does exactly that!
I’m Vova from the Screenful team. We build productivity analytics for modern leaders. Our Trello integrations make it easy to create dashboards and reports from your task data and share the actionable insights with your team. Today I want to show you how we forecast our team’s workload and how you can do it too.
Screenful’s newest Workload (forecast) chart may look similar to the Workload (planned) chart which I talked about in April. While the Workload (planned) chart was based on the set start and end dates for tasks, the new chart makes forecasts based on your historical velocity. Instead of set start and end dates, it looks at how fast you've completed work in the past and makes predictions assuming your future delivery speed will correlate with your past performance.
Getting started is easy and can be usually done in under two minutes: simply create a Screenful account, connect your Trello boards, and navigate to the new Forecasts section in the Insights tab:
The topmost chart shows your historical velocity as the amount of work completed per week. Below is the new Workload (forecast) chart that shows how long it takes to complete the remaining work based on the velocity history shown above.
These two charts help you to see your past velocity, and get a data-driven forecast for the remaining work. Instead of guesswork, you can use the data to make your own judgment!
In addition to creating Workload (forecast) in the Insights tab, you can also create it as a custom chart to then attach to your dashboards or scheduled reports. For this, go to the Charts tab and click Add new chart → Blank new chart, and select the Workload (forecast) as the chart type. The chart editor opens with the chart settings. You can select one or more data sources and any of your numeric fields as the unit. Here’s an example chart:
The chart shows a burndown of the remaining work on a weekly total until all the work is done. The leftmost bar is the current week and the rightmost bar shows the week when all the work is completed. As the work progresses, the remaining work reduces until it goes to zero.
At the top of the chart, you can switch between the Most likely, Optimistic, and Pessimistic scenarios. The most likely scenario assumes that you will complete the same amount of work (e.g. tasks or story points) as you’ve had on a median week in the past. In the Optimistic scenario, you will complete at least the same amount as the top 20% of the weeks in the past. In the pessimistic scenario, you will complete as much as the bottom 20% of weeks in the past. The percentiles are configurable in the chart settings so you can specify to yourself what you consider most likely, optimistic, or pessimistic for your future delivery speed 😃
In the above example, there are 173 open tasks right now, and it will take 10 weeks to complete the current backlog of work to be done.
By default, this chart assumes that you will complete roughly the same amount of tasks per week as you have done in the past. It uses a 12 weeks median as the basis for the forecast but you can adjust it in the settings.
And that’s how easy it is to tell when your project will be done!
That’s it for today. As always, I’d love to hear from you. Please do not hesitate to comment on this post or reach out to us at email@example.com if you have questions or feedback.