Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I filter "Open Issues" in EazyBI?

R. W.
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 15, 2019

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?

1 answer

1 accepted

0 votes
Answer accepted
R. W.
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 16, 2019

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])

Suggest an answer

Log in or Sign up to answer