We use Monday board for sprint planning (Agile). I would like to create a chart that will show predictability. For example, if the team commits to 100 items over a sprint and delivers 90, their planned-to-done rate would be 90%.
On my board for sprint planning, I create a new group for each sprint. Each group contains items assigned to engineers.
Each item has multiple columns, but I think for this task I need only two
Assignee - here I set the engineer assigned to the task
Status - to simplify, let’s say it can be either ‘Done’ or ‘In Progress’.
I am looking for a way to show the number of items assigned to each engineer divided on the number of items this engineer set to ‘Done’ during selected period of time.
This is a great idea of a use case. A couple of thoughts for this to work:
You can definitely house a lot of this information in one board however for this to be automated and tracked accordingly, it might be a good case for:
- Set Up what would be a Employee Directory
- Utilize the MATCH automation for the assigned tasks within your Scrum Board.
- Once the boards are connected directionally, every time a task is assigned it will associate with the employee solution.
- A formula column can be set up to count the amount of Done status items to see the predictability measurement.
- Mirror Timeline: This will allow to filter down to dates that you are looking for within the sprint as well.
Happy to walk you through this and even partner on a build. You can reach us here:
Hi @Oleg if an add-on is an option, I suggest taking a look at the Analytics & Reports by Screenful. It allows creating custom charts and task lists that you can share via scheduled reports or place in a monday dashboard.
Here’s an example Table chart that shows the progress of each team member during a sprint:
Notice the drop down menu on the top that allows switching between groups so you can view the numbers not only for the current sprint but also for any of the previous sprints. The columns are configurable so you can choose what stats to show for each row.
To add more visibility across all of your sprints, you can create another table so that each row is a group instead of an assignee:
Now you can see all of your sprints and their stats at once. The dropdown menu on the top allows switching between “All assignees” or any individual team member (the menu is configurable so you choose which column in your board you want to slice this view).
For tracking sprints we also have the typical agile charts such as burndown or cumulative flow diagram.
You can sign up for a free trial to give it a try. You can learn more about the Table chart from the Tour page and for configuring the quick filter on top of the chart, see this article.
If this kind of solution is of any interest to you, please don’t hesitate to reach out at firstname.lastname@example.org to get help in setting it up for your boards.