action #122074
closedcoordination #121867: [epic] Provide relevant metrics for Yam squad
[Research: 24h] Research about how to configure metric for Work in Progress tickets in Yam squad
Description
Motivation¶
As a Project Owner of Yam squad I would like to have a metric for tickets in Progress with state 'In Progress' for Yam squad project (QA / openQA Project / openQA Tests / qe-yam) and be able to visualize it Grafana.
The motivation is that this metrics will help us to understand what is the degree of collaboration between squad members. Our Scrum team is composed of 10 squad members, a Development Team of 9 squad member and 1 Scrum Master (excluding Project owner of the metric). In other words, the ideal number of task in progress at the same time is 10.
Currently we are working in parallel around 20-25 tasks and we have some spikes of 30. In order to have a good measure about our result with this saga #121981 we can display how is the fluctuation over time of this. In an ideal situation squad member do not need to pick more than one task and can be guided by other colleague to not be blocked, because most of our blockers are internal not external. Therefore this can be useful for the squad to take decision and see improvement.
This ticket is for the initial investigation about what we need to do.
We will need to discuss further with the developer of the project to process this metrics.
Initially we will need to provide a query for this metrics and then figure out next steps.
Apparently the part of grafana is not done yet, so we might try to use the python library to get this result (exclude from the time estimated of 24h, the time to setup your environment with python).
Acceptance criteria¶
AC1: Create query in progress that represent the metrics
AC2: Research code/documentation in redmine_statistics github project
AC3: Contact @ilausuch to figure out next steps
Additional information¶
This is the project (still in progress): https://github.com/ilausuch/redmine_statistics