How to Sum a status in Xray Test burnup for Test Plan

Questions & Answers
1

Hello,

I have a custom Test status called “VALIDATION” and I would like to sum this status with the measure “Xray Tests executed” in the burnup

Currently, I am using this measure:

-- annotations.group=Xray User defined 
Sum(
  Filter(
    --iterate through tests created before or on selected date
    Descendants([Xray Test].CurrentHierarchyMember, [Xray Test].[Test]),
    DateCompare(
      DateWithoutTime([Xray Test].CurrentHierarchyMember.get('Created at')),
      [Time].CurrentHierarchyMember.StartDate) < 1 AND
    --for each tests validate whether it has been executed until this date
    DateBeforePeriodEnd(
      ([Measures].[Xray Tests executed first date],
      [Time].CurrentHierarchy.DefaultMember),
      [Time].CurrentHierarchyMember)
  ),
  ([Measures].[Xray Tests executed], 
  [Time].CurrentHierarchy.DefaultMember)
)

Can you help me ?

Thanks

Renan

2

Hi @renanpress,

You can use the Xray Test Run Status dimension to select the particular status in the report pages. The calculated measure will return the first execution resulting in the particular status.

Please provide more details about the kind of help you need.
Best,

Roberts // support@eazybi.com