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