Can some one help to let me know if this meaure is correct, i am not getting any response back

Questions & Answers
1

CASE
WHEN [Measures].[Issues resolved] > 0
AND [Measures].[Total resolution workdays] > 1
AND [Issue].[Priority].CurrentMember IS [Issue].[Priority].[Critical]
THEN [Measures].[Total resolution workdays] / [Measures].[Issues resolved]

WHEN [Measures].[Issues resolved] > 0
AND [Measures].[Total resolution workdays] > 5
AND [Issue].[Priority].CurrentMember IS [Issue].[Priority].[Major]
THEN [Measures].[Total resolution workdays] / [Measures].[Issues resolved]

WHEN [Measures].[Issues resolved] > 0
AND [Measures].[Total resolution workdays] > 20
AND [Issue].[Priority].CurrentMember IS [Issue].[Priority].[Minor]
THEN [Measures].[Total resolution workdays] / [Measures].[Issues resolved]
END

1 Like
2

Hi, @Prakash_Rajamani

Welcom to the eazyBI community!

I answered this through support email: suppot@eazybi.com. I will add the formula for others who are looking for Issues breached based on specific Issue type criteria.

Sum(
 Filter(
   Descendants([Issue].CurrentMember, [Issue].[Issue]),
    DateInPeriod(
    [Measures].[Issue resolution date],
    [Time].CurrentHierarchyMember)
  AND
  DateDiffWorkdays(
    [Measures].[Issue created date],
    [Measures].[Issue resolution date])
    > 
    CASE [Priority].[Priority].GetMemberNameByKey([Issue].CurrentMember.get('Priority ID'))
    WHEN 'Critical' THEN 1
    WHEN 'Major' THEN 5
    WHEN 'Minor' THEN 20
    END)
   ),
 [Measures].[Issues resolved]
)

Kindly,
Ilze

1 Like