Scripted field to calculate average cycle time of a story in a Epic

Sai Praveen Aminigadda_1wvv11

Hello,

 

I'm looking for a groovy script that can give average cycle time of a story in an epic.

for instance, if an epic has a story and it closed in 2 hrs, the average cycle time will be 2 hrs.

if an epic has two stories and one closed in 1 hr and another one closed in 3 hrs, the average cycle time will be different.

any help would be appreciated.  

Note: we already have two scripted fields one gives the total cycle time of an issue and another one gives the number of issues in an epic.

Nic Brough -Adaptavist-

You should simply merge the two existing scripts into a third:

return (output of number of issues script / output of total cycle change script)

Note that the other option people may think of here is to calculate the third field from the first and second - do not do that, as fields are not always calculated in the order you think they are, so you could end up with the wrong answer.