Help Needed: Query for Xray Tests Not Executed in Last 6 Months

Questions & Answers
, ,
1

Hello EaZyBI team,

I need your assistance. Is it possible to get the following report in Jira Cloud with Xray Test Management?

All test cases in a workflow status other than “Obsolete”

That have not been executed in the last 6 months (or never executed)

Could you guide me on how to configure this in EasyBI?

Thank you as always for your support!

2

Hi,

A formula like this should work for this use case:

Sum(
  Filter(Descendants([Xray Test].CurrentMember,[Xray Test].[Test]),
   [Status].[Status].GetMemberNameByKey(
     [Xray Test].CurrentMember.Get('Status ID')
   )<>"Obsolete"),
   CASE WHEN
    IsEmpty(([Measures].[Xray Tests executed],
    [Time].[Previous 6 months]))
   THEN
    1
   END
)

This formula expects that you have created an aggregated member in the Time dimension “Previous 6 months”. The formula counts the tests that have no executions for the period corresponding to the Time dimension member.

Kindly,
Janis, eazyBI support

1 Like