Hi, I would like to build a report which displays how many days a ticket has been in Status XY by affected team. Which measures and dimension should I use for it.
I already tried multiple cases with status and transition to status but I never got the right numbers.
Welcome to the eazyBI community!
The current measure “Days in transition status” notes down the time at the moment when the issue changes status. The time is then registered against the combination of fields at the moment when the time was noted.
Therefore, all time spent in specific status is contributed to the assignee when exiting status.
The upcoming eazyBI version 7.0 will have a new set of measures “days assigned” that will track the change of statuses along with the change of assignees.
However, if the “affected team” is not related to the Assignee dimension and field change history is available in the issue changelog, you might create a JavaScript calculated customfield that registers spent time against the relevant dimension combinations.
You might modify the code from this community thread - Show cycle time during working hours - #2 by oskars.laganovskis
Regards,
Oskars / support@eazyBI.com