Average days in transition status till the end of period

Hi!
I need to build statistics to calculate the average time spent by a task in status, quarterly at the end of each period, taking into account all tasks. I plan to do it like this:

  1. Get all tasks created for the entire time until the end of the period (both open and closed tasks must be taken into account)
  2. Calculate the average time in status (if the task is still in status, then it is necessary to take into account the number of days spent in status until the end of the period)
  3. Build quarterly statistics that will show how many working days on average all tasks were in status (for example, in progress) as of the end of each period.

To solve this problem, I planned to use the filter “Days in transition status till now”, but it counts the time in status until the current moment, and not until the end of the period, which prevents me from building quarterly statistics. It is also necessary to take into account closed comments.

Hello @sn1ffer

Thanks for posting your question!
Measure “Days in transition status” is a historical measure, it can not return the time spent in status if your ticket is still open and you want to measure the time ticket is in status currently.
For that - you may consider looking at this community post - How to calculate Days in transition status including the time in current status

Here is another Community post - Workdays in specific status under predefined timeframe (period) - #2 by gerda.grantina that may be what you are looking for. When you import this, you may then calculate the Average time for the tickets.

Best wishes,

Elita from support@eazybi.com