Hello all,
We are using the new measure ‘Xray Test Plan Overall Execution Status’ for test plans over views.
This measure is returning the results in this syntax. PASS: 1, TODO: 15, BLOCKED: 1 in one column only.
We need to separate it into columns to create charts from it. It means |1|15|1| (with removing the text pass, Todo, blocked…) instead of |PASS: 1, TODO: 15, BLOCKED: 1| (one column only)
We tried custom Javascript code and a bit of MDX for that but still won’t able to achieve the result we want.
Is there any support on this use case please from your side?
Thank you!
Hi @Seif_Eddine,
The Test Plan Overall Execution Status is pulled in as a property, showing a summary test count by each status as one field.
You might use a calculated measure to process the string of all statuses and represent them as separate columns.
-
In Measures, define a new calculated measure that would look up the status name matching the selected test run status in the report and find the following number of tests.
CASE WHEN --only when test run statuses in the report
Not IsEmpty([Measures].[Xray Test Plan Overall Execution Status])
AND [Xray Test Run Status].CurrentHierarchyMember.Level.Name = "Status"
THEN --find status in summary matching Test Run Status name extract number following status name
Cast(
ExtractString(
[Measures].[Xray Test Plan Overall Execution Status],
[Xray Test Run Status].CurrentMember.GetCaption||": ([^,]*)",1
--set formatting to number so you could represent it in chart if needed
) AS NUMERIC)
ELSE --when no statuses selected show property as it is
[Measures].[Xray Test Plan Overall Execution Status]
END
More details on calculated measures and functions to process strings are described here: Calculated measures, ExtractString.
-
Select the new calculated measure to the report and choose to Drill into → the dimension “Xray Test Runs Status” (documentation on how to drill into measure by another dimension level).
-
Note that this approach works when you have individual Test plans on report rows because ‘Xray Test Plan Overall Execution Status’ is a test plan property, not a dynamically changing measure.
The report might look like this:
Best,
Zane / support@eazyBI.com
1 Like
Hi Zane,
I want to thank you so much for the solution, because it is working really well.
However, when I want to add an additional dimension in Pages like the “Fix version” for e.g. or any other custom field the data isn’t filtered at all accordingly to that, and it shows all the same duplicated in every column, arent there any solution for this please?
Thank you,
Seif
Hello @zane.baranovska ,
This is a gentle reminder regarding this question, any help will be really appreciated.
Thank you,
Seif