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?
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events