Show number of Issues that are customfield_xxx = successfull

Questions & Answers
,
1

I am filtering issues based on the IT domain, and I want to retrieve the records marked as ‘Successful’ for this month. I am using the MDX below, but even though there are records marked as ‘Successful’, nothing is returned. What could I be doing wrong?

Sum(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
NOT IsEmpty([Issue].CurrentHierarchyMember.Get(‘Month_RP’))
AND DateInPeriod(
DateParse([Issue].CurrentHierarchyMember.Get(‘Month_RP’)),
[Time].CurrentHierarchyMember
)
AND (
[Measures].[Issues created],
[Skorkart Etkisi].CurrentHierarchyMember
) > 0
),
1
)

2

Hi @iclalaslan,
I notice you’re using the Issues created measure in your filter. This measure is linked to the Time dimension by issue creation date, which means it’s affected by your Time selection in the report.

Since you want to filter issues only by the custom field date (Month_RP) using DateInPeriod, you should ignore the Time dimension for the “Issues created” measure. Try adding [Time].CurrentHierarchy.DefaultMember to the tuple with “Issues created” measure:

Sum(
  Filter(
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    NOT IsEmpty([Issue].CurrentHierarchyMember.Get('Month_RP'))
    AND DateInPeriod(
      DateParse([Issue].CurrentHierarchyMember.Get('Month_RP')),
      [Time].CurrentHierarchyMember
    )
    AND (
      [Measures].[Issues created],
      [Skorkart Etkisi].CurrentHierarchyMember,
      [Time].CurrentHierarchy.DefaultMember
    ) > 0
  ),
  1
)

This way, the formula will count all issues that match your criteria regardless of when they were created, and only the DateInPeriod condition will control the time filtering.

Kindly,
Gerda // support@eazybi.com