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?
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
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:
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?
The “Xray Test Plan Overall Execution Status” is a property, which is descriptive information and does not respond to any other dimension used in the report except for the dimension it describes (in this case, Xray Test Plan). The solution with calculated measure works only as prettify and splits the property value (String of statuses and test count) into separate items but does not add any additional logic to it.
If you would like to get execution results dynamically, then use Xray-specific measures.
Here are a few community posts you might find useful: