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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Nauris Malitis ,
Thank you so much for your suggestion.
Yes provided solution worked for me.
Thanks !!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.