How can I Create de average lead time?

Questions & Answers
1

Hi,
I need to calculate the average lead time from a project epics, and I calculate the individual (epic) lead time calculating the days between start date and due date.

How can I calculate the average and agregate it in the report? I would like the average lead time in the project

image
image1221×846 52.1 KB

thanks

2

You are creating a formula based on issue properties. They work only with issue dimension on rows expanded to specific Issues.

If you would like to calculate the average based on this, you would use Avg function over a set of issues.

Here I define a similar formula based on your two date custom fields:

AVG(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    -- for issues with start date only
    Not isEmpty([Issue].CurrentHierarchyMember.Get('Start Date'))
    AND
    -- show on time for issue CF due date, issues with cf due date only
    DateInPeriod(
      [Issue].CurrentHierarchyMember.Get('CF Due Date'),
      [Time].CurrentHierarchyMember)
    ),
    -- calculate days for relevant issue
    CASE WHEN
    -- check if issue is relevant for the report
    ([Measures].[Issues created],[Time].CurrentHierarchy.DefaultMember)  > 0 
    THEN
    -- calculate days
      DateDiffDays(
         [Issue].CurrentHierarchyMember.Get('Start Date'), 
         [Issue].CurrentHierarchyMember.Get('CF Due Date'))
    END
)

Please check the spelling for the properties. They should match case sensitive. With version 6.2, we suggest using autocomplete to fill in the property names.

Daina / support@eazybi.com

1 Like