How to use AND condition in dimension?

Hi Team,

We’re using eazyBI to generate a report that shows the linked stories with Epic.

Each epic can have 1-2 or more components. We want to generate a report to show Epic and linked stories based on components condition.

Suppose my components are A, B ,C , D.

Condition will be like-

  1. where components are ‘A’ AND 'B’
  2. where components are ‘A’ AND ‘B’ AND 'C’
  3. where components are ‘A’ OR ‘B’ so on…

We’ll not like to create user defined custom fields for every combinations and apply it.

Generally Dimension provides OR condition.

Is there any way so that we can use components as Dimension and apply AND condition on it ?

Thanks & Regars,
Narendra Kumar

Hi,

The idea for the solution is to implement a custom measure for filtering. The standard features available on UI cannot fully cover such a level of flexibility of filtering in eayzBI.

I tried the following custom measure for filtering. This measure gives true or false depending on whether the epic has all the components selected (which is “AND”) in the report pages:

-- for the epic level
Count(ChildrenSet([Components].CurrentHierarchyMember))
=
Sum(
  ChildrenSet([Components].CurrentHierarchyMember),
  ([Measures].[Issues created],
   [Issue Type].[Epic])
)

OR

-- for the story level
Count(ChildrenSet([Components].CurrentHierarchyMember))
=
Sum(
  ChildrenSet([Components].CurrentHierarchyMember),
  ([Measures].[Issues created],
   [Issue].CurrenthierarchyMember.Parent,
   [Issue Type].[Epic])
)

The solution expects that you should use the epic hierarchy of the issue dimension in the report and apply the row filter on this measure where the rows matches true. The example in the screenshot uses another customfield “Fruits”:

Kindly,
Janis, eazyBI support