Hi,
eazyBI does not replicate Xray functionality as those are two different tools. But you may build custom reports and calculations similar to reports and calculations in Xray.
Calculated measure Xray Test execution summary would match overview in the Xray for each Test Execution. When measure Xray Test execution summary is used with a Test Plan, then it returns all execution results within the test plan. If the test is executed twice (has two Test Executions) within a test plan, then it will appear twice in summary.
To get tests only by the last execution status in the selected Test Plan, you may create a new calculated measure in Measures. The calculation would go through all tests within a test plan and for each test get the last execution status in that test plan. The formula might look like this:
UPDATE: The formula is updated to use new dimension name “Xray Test Run Status”. Dimension “Xray Test Execution Status” was renamed to “Xray Test Run Status” in version 6.5.
CASE WHEN
[Xray Test Run Status].CurrentMember.Level.Name = "Status"
THEN --count tests by last execution status
Cache(NonZero(Count(
Filter(
--iterate throug all Tests
Descendants([Xray Test].CurrentMember, [Xray Test].[Test]),
[Measures].[Xray Tests with executions] > 0 AND
Order(
--iterate through execution statuses for a selected Test
Filter([Xray Test Run Status].[Status].Members,
[Measures].[Xray Tests with executions] > 0),
--order statuses by execution date descending
DateParse(
Generate(
Tail(
--iterate through all dates when a Test was executed
Filter([Time].[Day].Members,
[Measures].[Xray Tests with executions] > 0
)).Item(0),
Format([Time].CurrentHierarchyMember.StartDate, 'yyyy-mm-dd'),
",")),
BDESC
--name of the last execution matches status in columns
).item(0) IS [Xray Test Run Status].CurrentMember)
)))
ELSE --total count of tests with executions
([Measures].[Xray Tests with executions],
[Xray Test Run Status].DefaultMember)
END
This calculation is quite resourceful. I recommend selecting option Nonempty and running a report for a single selected Test Plan (see picture below).
Best,
Zane / support@eazyBI.com