Calculate average total of workdays that resolved tickets were in specific statuses

Questions & Answers
1

For Kanban teams, I want to show the number of resolved tickets per week (for past 3 months). Also, for the resolved tickets each week, how long (on average) were they in a status of “Development” or “Testing” (combined)…in workdays.

For example, for week 1, 3 tickets resolved
Ticket 1 - in Development for 1 day, in testing for 2 days → 3 days combined
Ticket 2 - in Development for 2 days, in testing for 2 days → 4 days combined
Ticket 3 - in Development for 3 days, in testing for 1 day → 4 days combined
So, average is 3.67 days for Week 1

Note, there are other statuses in the workflow (also ‘in progress’ category) but I don’t want to include these in this calculation.

The weekly resolved is easy to show. Really struggling with getting the correct calculation of average workdays in only these 2 statuses. What is the right way to calculate this?

2

Hi @TJohnson

You can use the Issue cycles in eazyBI to define necessary cycles by statuses: Issue cycles

During import, this will precalculate measures that you can use in the reports, like “Average workdays”.

​Let me know if this fits your use case or if you have any additional questions on this!
​Best regards,
​Nauris

3

Wow, this is great. I never knew about this feature. I think this will work perfectly. Thank you!

1 Like