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
[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]
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: