Calculate average age of issues in JIRA structure

Question

I would like to calculate the average age of issues I have loaded into a structure per formula column.

Currently I am calculating the number of unresolved issues via following formula:

SUM{If(resolution = undefined;1)}-1

But how to get the average age of the issues in a structure column?
Thx.

Sushmita Das_1ovmpa · Answer

Is that possible to show avg days like " Open since xx Days" through formula ?am trying use concate function but nothing is helping me to show "open since xx days".

Dima Kuzmin _ALM Works_ · Answer

Right you are, @rupert.schreder

There you go:

if level=1:

AVG

{

if resolution=undefined:

days_between(created,today())

}

rupert.schreder · Answer

Hello Dmitri,

thanks for information. Average age should be shown on project level... and I have a structure showing several projects.

But I think your formula needs to be extended to show only the average age of the still "unresolved" issues... I mean the already resolved ones should not be taken into consideration... any ideas?

Thx

Rupert