Determine lead time of issue via fix version release date

Hello,

I need to recalculate lead time of tickets as the time from when progress begins on them until they are released. The only way to capture when the tickets are released is by the release date on the fix version of the ticket.

I just don’t know how to approach this issue. I’ve looked for similar questions and I don’t believe this question has been asked before. Any help would be appreciated.

Hi @SamG

Please find one community post where was asked a similar question - about cycle time.

Perhaps, you could calculate the time between the specific status and the resolution date.
Or you could adjust the formula to calculate between a status and another status.

Martins / eazyBI support

Hi
I have tried the exact same thing but haven’t managed to make it work.
I’m trying to calculate the number of workdays that have passed between the ticket status “In Test” to the end of the sprint. So far I have written this script but it’s not working…

Thank you for your help!

@Thibault

I see you count workdays between the last time the issue went to A tester status until the Veresion release date for the selected Fix version (or Affects Version), but nothing in your code points to the Sprint end date.
Perhaps you can contact eazyBI support and provide more details about your use-case and the definition of your current report

Martins / eazyBI

Thank you Martins for your help!! :slight_smile:

1 Like