Hi,
I am trying to construct a bar chart report where it states the issues created and resolved within the same month. The calculated measure that I used for filtering out the issues created & closed in the same month is:
NonZero(SUM(Filter(
Descendants([Issue].Currentmember, [Issue].[Issue]),
DateInPeriod(
[Measures].[Issue created date],
[Time].CurrentHierarchyMember)
AND
DateInPeriod(
[Measures].[Issue resolution date],
[Time].CurrentHierarchyMember)
),
[Measures].[Closed]
))
The report takes Time (in months) as the row parameter and in the same report, I also would like to display the issues created earlier than the current month. For example; at the month of September there are 50 issues created and 25 out of this 50 is resolved. However, there are 100 more tickets created before September which I also would like to show separately.
How can I count the issues created earlier than the month that I am looking into and were not resolved during the month as well?
Thanks