Calculating release time for issues which dont have release date ones

I need to calculate for bugs those time to resolve and time to release. Unfortunately we dont have the release dates on the issues. Release date exist in just fix version. Issues have fix version. I need to create calculated measure for this. Could you please help me to get these metrics.

I’m trying with this but not working.

DateDiffWorkDays([Issue].CurrentHierarchyMember.get(‘Created at’),
[Fix Version].CurrentHierarchyMember.GetDate(‘Release date’))

Hello Nihal

Use (predefined) [Version release date] in [Measures]:

[time to fix] definition:
DateDiffWorkdays(
[Measures].[Issue created date],
[Measures].[Version release date]
)

Hope it helps!
Kind regards,
Vasile S.

2 Likes

Hi,

@VasileS shows an excellent example of how to do that.

Another solution is to write the formula to avoid the Fix Version dimension in the report. We can find for each issue the latest release date of all versions assigned to the issue (there can be several Fix Versions assigned):

DateDiffDays(
[Measures].[Issue created date],
TimestampToDate(
  Max(
    Filter([Fix Version].[Version].Members,
    [Measures].[Issues created]>0
    ),
    DateToTimestamp(
      [Measures].[Version release date]
    )
  )
)  
)

Kindly,
Janis, eazyBI support

1 Like

Thank you for your answers and solutions @VasileS and @janis.plume
I’ll try both of two. :slight_smile: