Calculate average age of issues in JIRA structure

[rupert_schreder]

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.

[Dima Kuzmin _ALM Works_]

Hello Rupert,

Please try this formula:

if level-1: AVG{days_between(created,today())}

Please feel free to change the level value - level may vary depending on multiple factors (how your structure is built, are there any folders, where do you need to show the average value etc.).

For instance, in my structure the formula shows the average value next to the structure's name on the top.

In order not to share any sensitive info here (and in any other case) you're always welcome to reach out to our support team directly at support@almworks.com. If you wish, you can share screenshots of your hierarchy and other details/questions there.

Kind regards,

Dmitrii Kuzmin 

[rupert_schreder]

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

[Dima Kuzmin _ALM Works_]

Right you are, @rupert_schreder 

There you go:

if level=1:

AVG

{

if resolution=undefined:

days_between(created,today())

} 

[Sushmita Das]

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".