Issue Aged between 7days and 21 days

Questions & Answers
, , , ,
1

Hi i am new to eazybi and trying to get open issues aged between 7 and 21 days and issues should be of Issue type ‘Service Request’ and ‘Incident’ so i created a calculated member under issue type

Issue Type Filtered -
Aggregate(
Except(
[Issue Type].[Issue Type].Members,
{ [Issue Type].[Bug],
[Issue Type].[Change],
[Issue Type].[Create a new user],
[Issue Type].[Problem],
[Issue Type].[Service Request with Approvals],
[Issue Type].[Task]}
))

Then trying to include in below calculated measure but it give no data to display as soon as i add condition

NonZero(Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
(
(
[Measures].[Open issues] > 0
AND
DateDiffDays(
[Measures].[Issue created date],
now()
) > 8
AND
DateDiffDays([Measures].[Issue created date],Now()
) < 22
AND
[Issue Type].DefaultMember IS ([Issue Type].[Issue Type Filter])

    )))))

Please let me know where i am going wrong

2

Refer to this link as this is an Aged Report we have developed. Please let me know if you want the report definition.

3

Display open issues greater than / less than 7 days old - Questions & Answers - eazyBI Community

2 Likes