TestRunStatus Custom field Xray in EazyBI

Questions & Answers
7

To create a Pie chart, you need some numbers, like a count of tests for each custom field “TestRunStatus” value.

This is what you may do.

  1. First, you may import the custom field as dimensions as well. Add one more line to advanced settings like this:

    [jira.customfield_NNNNN]
data_type = "string"
dimension = true

  2. Then select custom field for data import as a property and as a dimension. And import data.

  3. New dimension TestRunStatus by default won’t work with Xray specific measures as eazyBI relates all imported custom fields to Jira issues and measures for Jira core functionality, like, Issues created.
    To make new dimension TestRunStatus work with data from Xray, you may define a new calculated measure “Test count by TestRunStatus”.

    CASE WHEN
  [TestRunStatus].CurrentMember.Level.Name = 'TestRunStatus'
THEN 
  NonZero(Count(
    Filter(
      --iterate through all created tests
      Descendants([Xray Test].CurrentHierarchyMember, [Xray Test].[Test]),
      --which have TestRunStatus value the same as selected TestRunStatus member
      CoalesceEmpty([Xray Test].CurrentHierarchyMember.get('TestRunStatus'),"")
        MATCHES [TestRunStatus].CurrentMember.Name
      AND [Measures].[Xray Tests created] > 0)
  ))
END

Best,
Zane / support@eazyBI.com

1 Like