# TestRunStatus Custom field Xray in EazyBI **URL:** \ **Category:** Questions & Answers\ **Tags:** xray\ **Created:** [August 24, 2018, 7:13am UTC](https://community.eazybi.com/t/testrunstatus-custom-field-xray-in-eazybi/919 "2018-08-24T07:13:53Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![abbyfriend](https://community.eazybi.com/letter_avatar_proxy/v4/letter/a/59ef9b/32.png) [@abbyfriend](https://community.eazybi.com/u/abbyfriend)\ **Post date:** [August 24, 2018, 7:13am UTC](https://community.eazybi.com/t/testrunstatus-custom-field-xray-in-eazybi/919/1 "2018-08-24T07:13:53Z")
Hey guys, is there a way to display the XRAY Custom field “TestRunStatus” in EazyBI? The sample testRunStatus report uses the Execution Status. But Xray itself has a calculated field named TestRunStatus where the final Status of a TestRun is displayed, regardless of it’s Execution. Thank you in advance 🙂 Best regards, Anna ---
**Author:** ![WannaBeExpert](https://community.eazybi.com/letter_avatar_proxy/v4/letter/w/6a8cbe/32.png) [@WannaBeExpert](https://community.eazybi.com/u/WannaBeExpert)\ **Post date:** [September 11, 2018, 4:12am UTC](https://community.eazybi.com/t/testrunstatus-custom-field-xray-in-eazybi/919/2 "2018-09-11T04:12:54Z")
Hi,I am having a similar kind of requirement where I need to generate a graph in EazyBI on ‘Last Run status’ of each XRAY test…i.e. GroupBy **‘TestRunStatus’** … Example :: There are 100 tests in scope Final ‘TestRunStatus’ is 50 Pass & 50 Fail irrespective each test is executed n number of times. How do I represent this in EazyBI ---
**Author:** ![WannaBeExpert](https://community.eazybi.com/letter_avatar_proxy/v4/letter/w/6a8cbe/32.png) [@WannaBeExpert](https://community.eazybi.com/u/WannaBeExpert)\ **Post date:** [September 12, 2018, 8:58am UTC](https://community.eazybi.com/t/testrunstatus-custom-field-xray-in-eazybi/919/3 "2018-09-12T08:58:51Z")
Hi, This is really very urgent. Any help much appreciated. I am able to pull out ‘last execution status’ of each test but unable to COUNT the number of Tests which has its last execution status as Pass/Fail etc. ---
**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\ **Post date:** [September 14, 2018, 6:45am UTC](https://community.eazybi.com/t/testrunstatus-custom-field-xray-in-eazybi/919/4 "2018-09-14T06:45:55Z")
Hi, In eazyBI Jira import options, is a list of Jira custom fields with standard data types. You can also add Xray specific custom fields for data import. 1. In [eazyBI advanced settings](https://docs.eazybi.com/eazybijira/data-import/custom-fields/advanced-settings-for-custom-fields), add following lines to fetch the **TestRunStatus** values for data import: Replace NNNNN with the ID of the custom field TestRunStatus ID in your Jira. 1. In [eazyBI Jira import options](https://docs.eazybi.com/eazybijira/data-import/jira-issues-import#JiraIssuesImport-JiraCustomFields), select the **TestRunStatus** custom field for data import. And perform data import. 2. In the analyses new issue property **Issue TestRunStatus** is available for you. To get this property value for tests as well, define a new calculated measure in Measures. Best, Zane / [support@eazyBI.com](mailto:support@eazyBI.com) ---
**Author:** ![WannaBeExpert](https://community.eazybi.com/letter_avatar_proxy/v4/letter/w/6a8cbe/32.png) [@WannaBeExpert](https://community.eazybi.com/u/WannaBeExpert)\ **Post date:** [September 17, 2018, 6:34am UTC](https://community.eazybi.com/t/testrunstatus-custom-field-xray-in-eazybi/919/5 "2018-09-17T06:34:36Z")
Hi Zane, Thanks a lot for this reply. I will try to implement this and will get back to you. ---
**Author:** ![abbyfriend](https://community.eazybi.com/letter_avatar_proxy/v4/letter/a/59ef9b/32.png) [@abbyfriend](https://community.eazybi.com/u/abbyfriend)\ **Post date:** [October 11, 2018, 6:49am UTC](https://community.eazybi.com/t/testrunstatus-custom-field-xray-in-eazybi/919/6 "2018-10-11T06:49:44Z")
Hi Zane, Thank you very much 🙂 Could you also explain how to use the Custom field for example in a Pie Chart? Is there a way to do so? (I am a little bit confused because the TestRun Status is not a Dimension, so I am not shure on how to handle it properly.) Best regards, Anna ---
**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\ **Post date:** [October 12, 2018, 2:50pm UTC](https://community.eazybi.com/t/testrunstatus-custom-field-xray-in-eazybi/919/7 "2018-10-12T14:50:01Z")
To create a [Pie chart](https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-charts#Createcharts-Piechart), 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: 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, I **ssues created**. To make new dimension **TestRunStatus** work with data from **Xray** , you may define a new [calculated measure](https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-members) “Test count by TestRunStatus”. Best, Zane / [support@eazyBI.com](mailto:support@eazyBI.com) ---
**Author:** ![mjshaikh](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/fbc32d/32.png) [@mjshaikh](https://community.eazybi.com/u/mjshaikh)\ **Post date:** [February 25, 2019, 11:43am UTC](https://community.eazybi.com/t/testrunstatus-custom-field-xray-in-eazybi/919/8 "2019-02-25T11:43:08Z")
How to Create Report having Xray Test Custom field in column, Xray Test in Row and TestRunStatus in Cell. ![Eazybi](https://community.eazybi.com/uploads/default/original/2X/5/50a20f9f36188c2e71cd951d73980276e7a3f8a2.jpeg) ---
**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\ **Post date:** [December 1, 2022, 4:29pm UTC](https://community.eazybi.com/t/testrunstatus-custom-field-xray-in-eazybi/919/9 "2022-12-01T16:29:39Z")
Recently eazyBI released a new **version 6.6** , which includes several improvements for Xray data analysis, including new properties representing **“TestRunStatus”** as it is calculated on the Test issue. For more details, please see the documentation: [Xray Test Management](https://docs.eazybi.com/eazybi/data-import/data-from-jira-apps/xray-test-management) Best, Zane / [support@eazyBI.com](mailto:support@eazyBI.com)