Aggregated report with different projects filters

Questions & Answers
1

Hi,

I would like to have an aggregated report that will show issues created and Issues open on a set of project that has different filters

One project issues count will be based for example on Severity and other projects count will be based on project label.

Is there any recommendation to have the sum of both set of projects on issues count with the criteria’s above ?

2

Hi, @Ilham

Welcom to the eazyBI community. I’m sorry for not answering sooner.

Please consider using a sum of tuples to get the right issues, read more here: Tuple

For example, to count the issues for project Herbalism with the medium Priority and issues from the project Greenfield with the label plants, formula would look something like this:

(
 [Measures].[Issues created],
 [Project].[Herbalism],
 [Priority].[Medium]
)

+

(
 [Measures].[Issues created],
 [Project].[Greenfield],
 [Label].[plants]
)

Kindly,
Ilze support@eazybi.com

2 Likes
3

Thanks for your support Ilze