Sum of Blocker, Critical and Major open issues

Questions & Answers
1

Hi,

I am new to eazyBI and trying to create a graph in eazyBI. In my graph I am adding weekly open and resolved issues as bars. At the same time, I also want to track total number of open issues at a time. Creating a custom filter mentioned below does not give me the right number of total issues.

Aggregate({
[Priority].[Blocker],
[Priority].[Critical],
[Priority].[Major]
})

image
image.png2612×762 169 KB
. In this image trend lines are not giving me the right number.

This gives me result for a data range(week) for my time dimension. I am looking for all open defects till date. How do i add time measure to this query?

2

Is there any help I can get on above issue?

3

Hi Ruchi,

The Aggregate(…) by default is using Issues created measure (which is the default Jira issues cube measure). If you wish to override what measure you are aggregating, you should add it in the calculation. Please try the following

Aggregate({
  [Priority].[Blocker],
  [Priority].[Critical],
  [Priority].[Major]
}, [Measures].[Open issues]
)

Lauma / support@eazybi.com