How show list of open issues filter by time dimension

Questions & Answers
, , ,
1

Hello everyone
i have a measure called “Issues Abiertas” that is same than “Open issues” (replaced resolution date by closed date) and i need show the list of issues filtered by time dimension (month specific)
The problem is that the list doesnt show my issues, the sum is fine but when i expand the report only a few issues appear. How can that be fixed?

Thanks

Measure Issues Abiertas

CASE WHEN [Issue].CurrentMember.Level.Name <> 'Issue' THEN
  Cache(
    NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
      [Measures].[Issues created]
      - [Measures].[Issues closed]
    ))
    + [Measures].[Issues created]
    - [Measures].[Issues closed]
  )
WHEN [Time].CurrentHierarchyMember IS [Time].CurrentHierarchy.DefaultMember
THEN NonZero([Measures].[Issues closed])
ELSE
  -- optimized formula for drill through Issue
  NonZero(IIF(
      DateBeforePeriodEnd(
        [Issue].CurrentMember.get('Created at'),
        [Time].CurrentHierarchyMember) AND
      NOT DateBeforePeriodEnd(
        [Issue].CurrentMember.get('Closed at'),
        [Time].CurrentHierarchyMember),
    ([Time].CurrentHierarchy.DefaultMember,
      [Measures].[Issues created]),
    0
  ))
END

Report filtered by month

image

2

Hi @Emiliano_Romero

Since the formula is a bit complex, the Nonempty option in the Rows section unintentionally removes some of the Rows that you are interested in.

Please deselect the Nonempty button in the Rows section and enable the Hide empty → Rows instead.

​Best regards,
​Nauris

1 Like