Monthly average time from issue creation until first time assigned

Questions & Answers
1

Hello, I need some help to create a report at eazybi with the monthly average time from issue creation until first time assigned.

Can you help m, please.

Thank you

2

Hi, @tozemorais

Welcom to the eazyBI community.

To get the timestamp of the first time assigned, please consider using a tuple with the “Transition to first timestamp” and Assignee field. Please read more here about tuple: Tuple

([Measures].[Transition to first timestamp],
       [Transition Field].[Assignee])

To get the information on the issue level, please use the Descendants() and filter out the relevant issues using Filter.

The final formula should look something like this:

Avg(
  Filter(
    DescendantsSet([Issue].CurrentMember, [Issue].[Issue]),
    NOT IsEmpty(
      ([Measures].[Transition to first timestamp],
       [Transition Field].[Assignee])
    )
    AND
    DateInPeriod(
      [Measures].[Issue created date],
      [Time].CurrentHierarchyMember
    )
  ),
  DateDiffDays(
    [Measures].[Issue created date],
    TimestampToDate(
      ([Measures].[Transition to first timestamp],
       [Transition Field].[Assignee])
    )
  )
)

Kindly,
Ilze

3

Thank you @ilze.mezite!

works perfectly!

Best regards