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

Pragyesh Srivastav July 17, 2024

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

1 answer

0 votes
Nauris Malitis
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 18, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 18, 2024

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 July 18, 2024

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

Thanks !!

Like Nauris Malitis likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events