How do I filter the default calculated member "Open Issues" by a specific status?
I want to show all Issues that were either in status1 or status2 at each week in the past.
On example, if I had 3 open Issues in status1 and 2 open issues in status 2 at week 45 in 2019 I want to see 5 as a result for that week.
The following calculated member only gives me the right result for the last, respectively actual week:
([Measures].[Open Issues], [Status].[status1])
+ ([Measures].[Open Issues], [Status].[status2])
Is there a way to get the number of Issues, that were in one of the statuses for each week?
Allready figured it out. The following code gives me the results i want:
([Measures].[Issues history],[Transition Status].[status1])+
([Measures].[Issues history],[Transition Status].[status2])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.