I want to define the following formula in easybi and not finding a way

[Pragyesh Srivastav]

I have two labels A & B for tests
I want to visualize

1.Tests with Label A ,
2. Test with Label B,
3. Tests with Label A& B

[Nauris Malitis]

Hi @Pragyesh Srivastav 

Sure thing!

I'm going to interpret your request as follows:

1) Tests that have Label A, but don't have Label B (but may have other labels);

2) Tests that have Label B, but don't have Label A (but may have other labels);

3) Tests that have Label A and Label B (but may have also other labels);

Also, I'll assume that the "Test" is an Issue Type in your Jira.

You can start by first finding the Tests that have both the Label A and Label B by defining a new calculated measure in the Measures dimension.

Use this formula for the measure "Tests created with Label A and Label B":

Count(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    (
      [Measures].[Issues created],
      [Issue Type].[Test],
      [Label].[Label A]
    ) > 0
    AND
    (
      [Measures].[Issues created],
      [Issue Type].[Test],
      [Label].[Label B]
    ) > 0
  )
)

Now that you've found the Tests with both labels, you can use simpler formulas to find the Tests that have the Label A, but don't have the Label B and vice-versa.

For the measure "Tests created with Label A" you can use this formula:

(
  [Measures].[Issues created],
  [Issue Type].[Test],
  [Label].[Label A]
)
-
[Measures].[Tests created with Label A and Label B]

For the measure "Tests created with Label B" you can use the same formula but with switched values:

(
  [Measures].[Issues created],
  [Issue Type].[Test],
  [Label].[Label B]
)
-
[Measures].[Tests created with Label A and Label B]

Let me know if this fits your use-case or if I've misinterpreted your requirements!

​Best regards,

​Nauris / eazyBI support

[Nauris Malitis]

If you have a large eazyBI account with many issues imported, the Descendants function may work too slow or time-out.

In this case, you can add a new calculated JS field that will categorize these tests during the import process, so you'll have a new dimension with selections "Label A", "Label B" and "Label A and B".

Here's an example for this: https://community.eazybi.com/t/eazybi-community-day-2023-recordings-and-presentations/13555#h-7-nauris-mltis-making-sense-of-unstructured-data-using-javascript-in-eazybi-7 (starts at ~9:30)

​Best regards,

​Nauris

[Pragyesh Srivastav]

Hi @Nauris Malitis ,
Thank you so much for your suggestion.
Yes provided solution worked for me.

Thanks !!