Average days since last update

Questions & Answers
1

Hello,

I would like to have a single KPI that indicates the average number of days since last issue update for a set of issues.

I managed to have this indicator for each single issue:

DATEDIFFDays([Measures].[Issue updated date],Now())

But I cannot aggregate all these values to an average.

Thank you very much for your help.

Kind regards,

T.

2

You are using Issue property Issue updated date for this calculation. It works for Issue level calculations only, as you already identified.

You can define a set of issues where you are using this formula. The best way to address issue set is by using the function Descendants. However, in this case, you would like to apply some filters to get the correct set of issues as the report filters will not work there by default.

Here is an example report in our demo account Issue days overview by current status you can use a measure Average days in current status as an inspiration for your calculation.

The report works with measure Issue status updated date. You can substitute it with measure Issues updated date. The formula filters only open issues as we assume last update information is important for open issues in most cases.

Daina / support@eazybi.com