EazyBI query while creating bug report

Questions & Answers
1

Hi , I want to help to create a report. below is the brief description what I am looking for:

I am creating a bug report , based on the issue type (Bug) , component (XYZ) , [Affects version.by name]

The problem which I am facing , the bug list which I have is having multiple affected versions on some bugs.
But I want to select only those bugs which has only one affects version , which is “ABC”

I wrote the below query :slight_smile:

Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
(
[Measures].[Issues created],
[Issue Type].[Bug],
[Component].[XYZ]
) > 0
AND
(
[Measures].[Issues created],
[Issue Type].[Bug],
[Affects Version.By name].[ABC]
) > 0
AND
(
[Measures].[Issues created],
[Issue Type].[Bug]
) =
(
[Measures].[Issues created],
[Issue Type].[Bug],
[Affects Version.By name].[ABC]
)
AND
(
[Measures].[Issues created],
[Issue Type].[Bug]
) -
(
[Measures].[Issues created],
[Issue Type].[Bug],
[Affects Version.By name].[ABC]
) = 0
)
)

But the above query is giving me the list of the bugs which has other affected versions as well alongwith “ABC”.

But I want the count of only those bugs which has one and only “ABC” as affected version.

Can somebody help me here please!

Thanks in advance:)

2

Hi SRIVASP,
Welcome to the eazyBI community!

Filtering for a specific single value in a multi-select field can be tricky, but you might consider adjusting your formula to use the “Issue affects versions” property field, which lists all affected versions as a comma-separated list (therefore, it is easy to filter out only one value).

Try following formula:

Sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issue affects versions]="ABC"
),
([Measures].[Issues created],
[Issue Type].[Bug],
[Component].[XYZ])
)

Let me know if that works for you or if further adjustments are needed.

Best,
Ilze