Need to get Date Differece Hours on Month wise

Questions & Answers
, ,
1

Hi
A calculated measure was created for the date difference between the created date and the resolved date.
Measure works fine for issues in columns, but not when time is selected in columns.
Below is the formula used for Measure

DateDiffHours(
[Measures].[Issue Created date],
[Measures].[Issue resolution date],
)

Thanks.

2

Hi @Nagaraju_T ,
If you want to calculate the difference time-wise, then you need to:

  1. use DescendantsSet() function to iterate through all issues,
  2. Measure “Issues resolved”>0 to bind the measure to Time by the issue resolution date
  3. use Avg() to create an average formula for the issue resolution time.
Avg(
  Filter(
    DescendantsSet(
      [Issue].CurrentHierarchyMember, [Issue].[Issue]),
      [Measures].[Issues resolved]>0
  ),
  DateDiffHours(
    [Measures].[Issue created date],
    [Measures].[Issue resolution date]
  )
)

Or you can use a predefined measure, “Average resolution days,” and multiply it by 24 to get the resolution hours.

best,
Gerda // support@eazybi.com

1 Like
3

Thank you so much @gerda.grantina
The measure is working fine.

1 Like